rollxnut Posted May 29, 2008 Posted May 29, 2008 I have a cd database with names and emails. I have been hired to translate it to a excel spreadsheet. its based on the job and not the time spent. There is over 32,000 names/emails, and typing each one out is OUT OF THE QUESTION. Can someone point me into the right direction or tell me how to extract them all. I can see a spreadsheet of information but when I go to copy it it show some copyright protection statement. PLEASE HELP. I think the info in is a file with an .rsrc file extension. I've googled everything I know and this is my last hope... Quote
Sparda Posted May 29, 2008 Posted May 29, 2008 http://www.google.co.uk/search?q=mysql+to+csv What's your job again? Quote
rollxnut Posted May 29, 2008 Author Posted May 29, 2008 http://www.google.co.uk/search?q=mysql+to+csv What's your job again? I'm just helping out a friend that has a business.. That link is soo far over my head. I forgot to say that I'm somewhat of a noob. oh.. and I'm running a PPC mac Quote
Sparda Posted May 29, 2008 Posted May 29, 2008 What program 9on the mac) is used to access the information with in the database? Quote
rollxnut Posted May 29, 2008 Author Posted May 29, 2008 this is the file. http://www.mediafire.com/?9xbx4lcdwtx I think this has the data I'm looking for. I would like it in an excel spreadsheet if possible . Quote
Sparda Posted May 29, 2008 Posted May 29, 2008 The file you linked to seems to have some relevance to this. I can't see what it is for now. It would also seem that the file is possibly an executable of some nature, and does not hold any relevant data to what you wish to archive. Quote
DingleBerries Posted May 29, 2008 Posted May 29, 2008 I am just taking a shot at this but have you tried printing it to a .pdf file and then from there converting that information to a word file and merging it into an excel. Quote
rollxnut Posted May 29, 2008 Author Posted May 29, 2008 I am just taking a shot at this but have you tried printing it to a .pdf file and then from there converting that information to a word file and merging it into an excel. when changing to a PDF, it only does the row highlighted and you can not highlight more then one Quote
moonlit Posted May 29, 2008 Posted May 29, 2008 this is the file. http://www.mediafire.com/?9xbx4lcdwtx I think this has the data I'm looking for. I would like it in an excel spreadsheet if possible . ...am I the only one here who thinks that posting a database related to your job on a public forum via a public file host is unbelievably retarded? Or, perhaps it's not actually for work at all, perhaps it's just for your own enjoyment. Quote
rollxnut Posted May 29, 2008 Author Posted May 29, 2008 ...am I the only one here who thinks that posting a database related to your job on a public forum via a public file host is unbelievably retarded? Or, perhaps it's not actually for work at all, perhaps it's just for your own enjoyment. I was asked if I could do this, and I told him I would give it a shot. ( I'm sure he will pay me something ) I dont mind repaying the person that can help me with this either. maybe paypal? Quote
Sparda Posted May 29, 2008 Posted May 29, 2008 A clue please, what program is used to make use of the data? Quote
rollxnut Posted May 30, 2008 Author Posted May 30, 2008 A clue please, what program is used to make use of the data? I dont know, I put the CD in, and it auto loads Quote
digip Posted May 30, 2008 Posted May 30, 2008 Isn't there a resedit for Macs? Or unix variant that can edit rsrc files? Quote
rollxnut Posted June 3, 2008 Author Posted June 3, 2008 would it help if I just put all the files online somewhere? Quote
digip Posted June 3, 2008 Posted June 3, 2008 would it help if I just put all the files online somewhere? Not unless you want people stealing important private information from the db. Not sure what's in it, but if my info was in there, I wouldn't want it being shared with a hacking network of people(or anyone for that matter). Quote
Sparda Posted June 8, 2008 Posted June 8, 2008 File extension != file type. File extension = program association and nothing more. Quote
rollxnut Posted June 16, 2008 Author Posted June 16, 2008 I need to get this cd's information into a excel spreadsheet without hand typing it all. PLEASE HELP http://btjunkie.org/torrent/Contents/23037...b6db843de36230b Quote
Sparda Posted June 17, 2008 Posted June 17, 2008 I need to get this cd's information into a excel spreadsheet without hand typing it all. PLEASE HELP http://btjunkie.org/torrent/Contents/23037...b6db843de36230b God helps those who helps them selves. Please give us a clue as to what the name of the program that was used to create this 'database'. Quote
Sparda Posted June 17, 2008 Posted June 17, 2008 not a clue. No one can help, you best get typing. Quote
Justin Ewing Posted June 17, 2008 Posted June 17, 2008 Try this mysql -u username -ppassword --batch -e "select * from mytable" mydatabase > mydata.txt or SELECT * INTO OUTFILE "c:/mydata.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" FROM my_table; Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.