padlocked17
Registered User.
- Local time
- Today, 15:57
- Joined
- Aug 29, 2007
- Messages
- 276
All,
I'm working with being able to access data from an Oracle Database. I can't link to the Oracle Database through an OBDC connection due to computer limitations so I have one user that uses Access to create a Batch file that downloads text files containing all of the data I need everyday. I then have the text files linked in Access with Append Query's that move the data into the Database.
The issue I'm running into is that I want to be able to change the location of the linked tables. Every tool and sample of code I have come across can change the linked tables, but when it comes to the linked text files, I can't seem to figure out how to relink them. Should I stick with this approach of having linked text files, or should I take some other approach.
The advantage I have of using linked text files is that I can use the batch files to update the text files on a daily basis, run my queries, and have up to date data in the database.
Any suggestions or ideas?
Thanks!
I'm working with being able to access data from an Oracle Database. I can't link to the Oracle Database through an OBDC connection due to computer limitations so I have one user that uses Access to create a Batch file that downloads text files containing all of the data I need everyday. I then have the text files linked in Access with Append Query's that move the data into the Database.
The issue I'm running into is that I want to be able to change the location of the linked tables. Every tool and sample of code I have come across can change the linked tables, but when it comes to the linked text files, I can't seem to figure out how to relink them. Should I stick with this approach of having linked text files, or should I take some other approach.
The advantage I have of using linked text files is that I can use the batch files to update the text files on a daily basis, run my queries, and have up to date data in the database.
Any suggestions or ideas?
Thanks!