I will try to explain what I have. I have a set-width text file that is updated on a daily basis. I need to copy this information into an access table when the user opens the database. The existing table will be totally replaced by the new data. I don't know if I want a link table. I don't want the text file to be unavailable or otherwise affected by my program. The text file is on a server. If I set it up as a link table is there ANY possibility that my program could alter the text file data? If so, I can't use a linked table. Is a linked table the way to go, or should I write a macro that when the database is opened, it copies the data from the text file and places it into a blank table?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automatic import
- Thread starter poporacer
- Start date
Did you set up a test environment with a copy of the text file and then test this?poporacer said:
Duane
Hook'D on Access
MS Access MVP
- Thread starter
- #3
Well I did some testing and at first a linked table seemed like the way to go BUT... I soon found out that if one instance of access is opened with the linked table, it is locked from any other Access DB to link to. There is the possibility that 3 or 4 users might need to be getting data from this file and I don't want to lock them out. So how can I copy the data from a text file and put it into a table?
There is a wizard that can guide you through importing a table and creating a specification.
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
- Locked
- Question
- Locked
- Question