
June 1st, 2006, 01:54 PM
|
|
Registered User
|
|
Join Date: May 2006
Posts: 6
Time spent in forums: 1 h 59 m 22 sec
Reputation Power: 0
|
|
Importing Excel spreadsheet to Access database daily
I need some help on this one.  I have two Crystal Report generated Excel spreadsheets that are auto-updated on a daily basis. One spreadsheet contains computer assets, type, model, locations, etc. The second spreadsheet has users assigned to them, phone numbers, etc. I need to import these in to existing tables with numerous filters into my Access database weekly. They don’t change a whole lot but I need the changes to be reflected in my database.
The way I have it setup now is through a linked table, then I use a “Make table query” to filter the data.
My problem is the filtered table has relationships set up that I have to delete then recreate every time I need to run the “Make table query” because it has to delete the old table first.
Is there a better way to make this happen?
|