import csv file from a web server

S

slescure

i have a csv file sitting on a web server - i don't have the option
(easily anyway) to ftp it to a file server.

I want to import it to Access using VBA. I thought the TransferText
method might work, something like:

DoCmd.TransferText acImportDelim, , "tblImportData",
"http://www.etc...", False

can i use a URL with this statement? apparently not, since it doesn't
seem to work...

is there another method i should be looking at.

I guess i could convert the csv to xml and try and import that, but
that's quite a bit of work.

any ideas?

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

Similar Threads

Adding data to MS Access from csv file 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Import Spec CSV 7
Convert a csv to xls prior to import 2
Trying to create custom labels from an csv file + Need items numerically counted out 0
import error 1
Cannot import CSV file into ACCESS 1
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0

Top