Importing from web to Access

  Morphy 11:44 31 Mar 2003
Locked

I have a URL that generates a CSV file from my website, and I want to import it into a table in Access.

So far Ive managed to do via Excel as a web query, but would really prefer to do it directly.

Help!!

  Morphy 12:43 11 Apr 2003

It doesnt seem as if anyone has any ideas on that.

How about if I have a bit of code that saves the CSV file to a certain location, say, C:\My Documents.

I could then import it from there, but Im not sure about the 'saving the file' bit.

Anyone?

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Indie publisher Canongate’s top 10 book covers of 2017

New iMac Pro release date, UK price & specs rumours

Tablettes Amazon Fire : quel modèle choisir ?