Linking Access and Excel 2003

[crashoverride]

What is the easiest way to create a link between access 2003 databse and
excel 2003. i want to import data from excel to access and export from access
to excel.
(e-mail address removed)

 

[Ken Snell \(MVP\)]

Two methods:

(1) Link to the spreadsheet in the EXCEL file (use File | Get External Data
.... | Link).

(2) Use TransferSpreadsheet method (macro or VBA) to copy data from/to EXCEL
worksheet. Note that this method is the only one you can use if the EXCEL
file contains strings longer than 255 characters, or if the data to be
exported to EXCEL contains strings longer than 255 characters.

Caution: Both have some limitations with data types that ACCESS/Jet will
assign to the data; may not always be what you want.