RE: [PCTECH] automagically import a .CSV into Access db table from CL?

["Dan Bale" <dbale@xxxxxxxxxxxxx>]

> The user would have to go into Access (or create a icon) that would update
> the table.

If I have to go into Access to do it, I'm not that much farther ahead than
if I just manually import it.

> I would think that you could even use the windows scheduler.

Well, this would be the magic box then.  I have no idea how this would work.
Is there some other method of invoking the import automatically?

db

> -----Original Message-----
> From: pctech-bounces@xxxxxxxxxxxx / Ritsema, Doug B
> Sent: Wednesday, October 20, 2004 5:15 PM
>
> You should be able to import (not link) a table into Access via ODBC.
>
> The user would have to go into Access (or create a icon) that would update
> the table.  I would think that you could even use the windows scheduler.
>
> The Access table is a copy of your live data and not linked to the live
> data.  We did something similar with our first web enablement of our data.
>
> Doug