rollxnut Posted May 29, 2008 Share 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 Link to comment Share on other sites More sharing options...
Sparda Posted May 29, 2008 Share Posted May 29, 2008 http://www.google.co.uk/search?q=mysql+to+csv What's your job again? Quote Link to comment Share on other sites More sharing options...
rollxnut Posted May 29, 2008 Author Share 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 Link to comment Share on other sites More sharing options...
Sparda Posted May 29, 2008 Share Posted May 29, 2008 What program 9on the mac) is used to access the information with in the database? Quote Link to comment Share on other sites More sharing options...
rollxnut Posted May 29, 2008 Author Share 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 Link to comment Share on other sites More sharing options...
Sparda Posted May 29, 2008 Share 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 Link to comment Share on other sites More sharing options...
DingleBerries Posted May 29, 2008 Share 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 Link to comment Share on other sites More sharing options...
rollxnut Posted May 29, 2008 Author Share 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 Link to comment Share on other sites More sharing options...
moonlit Posted May 29, 2008 Share 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 Link to comment Share on other sites More sharing options...
rollxnut Posted May 29, 2008 Author Share 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 Link to comment Share on other sites More sharing options...
Sparda Posted May 29, 2008 Share Posted May 29, 2008 A clue please, what program is used to make use of the data? Quote Link to comment Share on other sites More sharing options...
rollxnut Posted May 30, 2008 Author Share 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 Link to comment Share on other sites More sharing options...
digip Posted May 30, 2008 Share Posted May 30, 2008 Isn't there a resedit for Macs? Or unix variant that can edit rsrc files? Quote Link to comment Share on other sites More sharing options...
rollxnut Posted June 3, 2008 Author Share Posted June 3, 2008 would it help if I just put all the files online somewhere? Quote Link to comment Share on other sites More sharing options...
digip Posted June 3, 2008 Share 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 Link to comment Share on other sites More sharing options...
VaKo Posted June 3, 2008 Share Posted June 3, 2008 Torrent that shit now! Quote Link to comment Share on other sites More sharing options...
Famicoman Posted June 5, 2008 Share Posted June 5, 2008 Torrent that shit now! QFE Quote Link to comment Share on other sites More sharing options...
rollxnut Posted June 8, 2008 Author Share Posted June 8, 2008 what about a .vdb to excel? Quote Link to comment Share on other sites More sharing options...
Sparda Posted June 8, 2008 Share Posted June 8, 2008 File extension != file type. File extension = program association and nothing more. Quote Link to comment Share on other sites More sharing options...
rollxnut Posted June 16, 2008 Author Share 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 Link to comment Share on other sites More sharing options...
Sparda Posted June 17, 2008 Share 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 Link to comment Share on other sites More sharing options...
rollxnut Posted June 17, 2008 Author Share Posted June 17, 2008 not a clue. Quote Link to comment Share on other sites More sharing options...
Sparda Posted June 17, 2008 Share Posted June 17, 2008 not a clue. No one can help, you best get typing. Quote Link to comment Share on other sites More sharing options...
Justin Ewing Posted June 17, 2008 Share 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 Link to comment Share on other sites More sharing options...
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.