Get External Data Macro

[Harley Guy]

Now that I have the server inventory part of this database looking good, I know need to focus on getting external information regarding database backups.



Procedurally, I can instruct users, when they recieve the files from the DBA groups, to give them specific names and to put them in a specific place.

What I need to code is to have Access look to a network drive for the file and import it to a table.

Any ideas would be most helpful...

Thanks in advance!

[TheShabz]

Will these files be excel files? If so..

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ImportSpecification", "FileName", True

changing the excel version to whatever you have, and the filename to the path of the file.

[Harley Guy]

Yes, these will be Excel files...Thanks!