downloading realtime CSV Info

  • Thread starter Thread starter Steve G
  • Start date Start date
S

Steve G

Hi!
Is there a way I can have my database retreive CSV files
from a web site on a continious bases, WITHOUT having to
download it manually AND be put into one column. I import
information from several different sites which are all in
CSV format and continuously updated. I've tried using a
marco and the retreive data feature in Excel, only to have
the information be placed in one column when I want it to
be broken into several and stored in my Access database.
-- Thanks
 
Steve,
That is certainly possible.
YOu can use FTP or, if the csv file is within your network, just a simple
mapped drive or some other mechanism, to get the file.
You can also import the data into access and automate the whole thing. I
have done something very similar with SQL DTS
but the concept is easily transferable to Access.

You will have to use a fair amount of VBA coding to manage this process -
from starting it up repeatedly, fetching new files,
and launching the import.
You can have pre-defined import specifications that define how the source
data is laid out - columns and datatypes,
which you can then use to import to different tables.

look here for getting started on FTP within Access:
http://www.mvps.org/access/modules/mdl0037.htm

HS
 
Back
Top