Export to a TXT-file

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Hello JaRa,

I'm using MS Office XP, thus Access 2002.
I'm not familiar with SQL server or MSDE(??)
 
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
 
Raoul,

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