Importing from excel

[Guest]

Hi i am working with office 2000 and need to inport data from Excel into
Access 2000 can anyone tell me how to do this

 

[Rick B]

File/Get External Data/Import

This will allow you to import data from Excel into an existing or new table
in Access.

You could also link to the Excel file if you need Access to be able to see
updates to the Excel file and use the data real-time.

 

[Bruno Campanini]

Hi i am working with office 2000 and need to inport data from Excel into
Access 2000 can anyone tell me how to do this
--

Supposing:
- you want to import from Access;
- Excel import file is not password protected.

DoCmd.TranferSpreadsheet acImport, _
SpreadsheetType := acSpreadSheetTypeExcel9, _
TableName := "AccessTableName", _
FileName := "ExcelFileNamePath", _
Range := "Excel Named Workbook's Range", _
HasFieldNames := True

You can define Excel range also with: "Sheet2!C512"

Bruno