csv file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 24 Nov 2004 14:16 GMT

I have a file which is downloaded to my PC everyday in csv
format and I would like to automatically import this file
exactly as it is field by field into an access database ,
so I can write queries.
Can anyone help. Thanks again.

Reply to this Message

John Nurick - 25 Nov 2004 07:14 GMT

Hi,

If you just need to query the most recent version of the text file,
there is no need to import the data. Instead, you can just use a linked
table, or even write queries that reference the text file directly,
using SQL syntax like this:

SELECT * FROM TestImport
FROM [Text;HDR=No;Database=C:\MyFolder\;].MyFile#txt

On Wed, 24 Nov 2004 06:16:46 -0800,

>I have a file which is downloaded to my PC everyday in csv
>format and I would like to automatically import this file
>exactly as it is field by field into an access database ,
>so I can write queries.
>Can anyone help. Thanks again.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message