update external data

[keithcrooks]

Hi guys,

I have a database on a PDA that I export to a CSV file onto my desktop (but could get a Mdb)
I need Access 2003 when opened to look at the Csv or Mdb file and import the data.

this is easy in 2007 but cant seem to figure 2003

cheers in advance

 

[PaulO]

Think you just need your Access database to link to the .csv file

File > Get External Data > Link Tables

then select Files of Type = Text and browse to where the file is located ...

Once linked you can query the data and do whatever you want with it ...

 

[keithcrooks]

Many thanks for the reply, I will give it a go.