Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
excel data coversion
Simon, Thanks for the link, and advice. I had not been to that particular forum at notes.net. Have a good weekend. K -
excel data coversion
Simon, I'll definately try the text method next time, but it seems a little over my head at the moment. I do have another question about the csv method, I ran the code you sent to check for the paths and everything is opening fine now, but now I am having trouble with the .col method, nothing... -
excel data coversion
Simon, If I save in straight .txt would I still use the doc.Firstname = .cell(col 7).Value format. I thought it would be easier as csv files because each field would be delimted and easier to match with my database. Could you tell me a little more about the text method, I haven't seen any... -
excel data coversion
There is an existing export agent running which converts to a csv file. I didn't write this code and there is no documentation, so I am having trouble finding the sort key. A few questions since there are 30 or so people putting this file on their local drive. How do I identify the name of the... -
excel data coversion
I am having trouble importing from an excel spreadsheet and putting it back into my database by key. Anyone have any code? Thanks
