IMPORT Button/Macro to import a Excel file

[kinselas]

HI Please Help me.
I would like to create a button on a form, whereby I can import data from a Excel spreadsheet. What is the macro or code. I am using Access 2000.
Thanks

 

[cew657]

You will need to use the DoCmd.TransferSpreadsheet command. It works like:

DoCmd.TransferSpreadsheet [transfertype][, spreadsheettype], tablename, filename[, hasfieldnames][, range]

If you want more information on this and an example, then click on help and type in TransferSpreadsheet.

cew657

 

[kinselas]

Cew657 thank you for your reponse, but I am having a problem with the syntax Please help. I am import from Excel 2000

DoCmd.TransferSpreadsheet [acImport], [acSpreadsheetTypeExcel9], [Outlets], [u:\Extract.xls], [True]

 

[cew657]

The brackets are what is causing the problem. The brackets were to show the components of the command. This is what your command would look like:

DoCmd.TransferSpreadsheet acImport,acSpreadsheetTypeExcel9, "Outlets", "u:\Extract.xls", True

HTH
cew657