medreports2
Technical User
I work with a 3rd party software which uses an Access database. The structure of the software is such that they provide a utilty for importing records into 1 table (via csv), but not into some of the other relational tables directly related to it in the app. I provide some clients with database maintenance, and am not able to provide them with an import utlity to insert records into these other tables, requiring a timely exchange of files and disruption of sql synchronization utilities. (basically P.I.A.)
What I need to be able to do is take an excel spreadsheet containing an export of these new records into one of these tables (preferably with data locked down or invisible), and create a function that will import the data into the corect Access table. The Access database is pasword protected as well (I have pw).
Db name = MasterTable
Table Name = Accessory
Any ideas?
What I need to be able to do is take an excel spreadsheet containing an export of these new records into one of these tables (preferably with data locked down or invisible), and create a function that will import the data into the corect Access table. The Access database is pasword protected as well (I have pw).
Db name = MasterTable
Table Name = Accessory
Any ideas?
