Jump to content

Recommended Posts

Posted

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...

Posted

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.

Posted

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.

Posted
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

Posted
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.

Posted
...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?

Posted

Isn't there a resedit for Macs? Or unix variant that can edit rsrc files?

Posted
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).

Posted

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;

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...