Copy comma delimited string to table




I am trying to automate importing data from the web using Web Browser
ActiveX, I ended up with a string that containes imported text with fields
delimited by a comma, Now I would like to know the best way (automated again)
to copy this string into my database directly. The current solution that
worked for me is saving the string to a text file using an external dll
library function call then importing the file using 'TransferText' method.
Any help with some coding would be great, thanks!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question