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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Open Excel file for import into Access database
- Thread starter ef61778
- Start date
fredericofonseca
IS-IT--Management
Open a new/existing DB.
Go to file->Get external Data-> Import-> select the Excel file you wish to import.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
Go to file->Get external Data-> Import-> select the Excel file you wish to import.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
ComputeThis2
IS-IT--Management
From within Access you can use DoCmd.TransferSpreadsheet Method:
Search TransferSpreadsheet in Access for parameters, etc.
Hope this helps.
Code:
MyFilename = "C:\Filename.xls"
MyTablename = "ImportTable"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel5, MyTablename, MyFilename, TrueHope this helps.
- Status
