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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by moonie

  1. moonie

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

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

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

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

    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

Part and Inventory Search

Back
Top