Export to a TXT-file

[Guest]

Hello,
due to prevent that my database is growing to large, I'm loocking for an
export solution.
Every 3 months, I receive data (600.000 records).
These records have a date field as reference.
I was tinking about a solution to export the new information to an external
tabel (txt-file) where I should append the new data.
With this solution I'm able to link the txt-file into my database and use
this linked table as master for my querys.
Does someone have any clou to solve this problem.
Thank you

 

[Guest]

Which access are you using?

I would suggest to store everything under SQL server or MSDE since querying
a txt file is totally not perfomant since no indexes will be used.

- Raoul

 

[Guest]

Hello JaRa,

I'm using MS Office XP, thus Access 2002.
I'm not familiar with SQL server or MSDE(??)

 

[Guest]

Well basically it's an advanced datacontainer which works like Access
Definitly when you select to create an Access project. Everything will look
familiar the only big difference is that action queries will become stored
procedures but will look for 80% like plain Access queries.

What i would suggest is to export this table to sqlserver and have linked in
your main access application through odbc.
With this many records it's really worth to study Access Projects and MSDE

- Raoul

 

[Guest]

Raoul,

thank you for your quick response.
I'll folow your suggestion and go for a MSDE solution.

 

[SusanV]

You could also export all the data to another access database and use a
linked table...