Import data from Text Files

[Jurgen Verhelst]

Hi all,

I need to synchronise data from a text file in my
database... Any ideas on how to go about that? the text
file is generated by a linux accountancy package

I am as far as getting only the changed records in the
text file but i need some code to look up the same record
in my database and updating that record....


thanks

ez

 

[John Nurick]

Hi Jurgen,

The normal approach is

1) use File|Get External Data|Link to create a linked table on the
textfile.

2) build an update query that joins this linked table and the relevant
table in your database on the key fields, so that each record in the
linked table is joined to the corresponding record in the internal
table, and fields in the internal table are updated from the linked
table.

Hi all,

I need to synchronise data from a text file in my
database... Any ideas on how to go about that? the text
file is generated by a linux accountancy package

I am as far as getting only the changed records in the
text file but i need some code to look up the same record
in my database and updating that record....


thanks

ez

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.