Importing into Access

[chrisguk]

Hi,

I am using the following code to import my spreadsheet into Access but I have a split database main.adb and main_be.mdb. How can I modify this code to put the data into the linked table?

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel7, "tblCustomerDetails", "myfile.xls", False,

Sorry to add to that. What is the file name is not all the same, how can I dynamically select my file?

 

[Rx_]

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"MyTable", "C:\MyFile.xls", True

Reminder: TRUE means "tell Access that the first row is column
headings, so don't import the column headings.

Dim MyXLFileName as String
{ your code that assigns the varable MyXLFileName as a string }
example: MyXLFileName = "myfile.xls" ' use an input box (worst case) or some interface for the user to select a valid Excel file name (best case).
..., "myfile.xls", False becomes--> ..., MyXLFileName, False

 

[smig]

If you use linked tables your data will be imported into the linked ones

 

[chrisguk]

If you use linked tables your data will be imported into the linked ones

I got the linked table situation sorted, that was just a typo so the program created its own table.

For the imprt i was hoping there was a solution available to open a windows dialogue like you do in explorer and select the file to import?

 

[smig]

I got the linked table situation sorted, that was just a typo so the program created its own table.

For the imprt i was hoping there was a solution available to open a windows dialogue like you do in explorer and select the file to import?

It's possible, but involve more coding
do a search for Browse in the forums