Can I import excel spreadsheets into access?

  • Thread starter Thread starter Amos33
  • Start date Start date
You can do it manually via File | Get External Data (but note that this will
truncate long strings, and some other issues pop up). You can use
TransferSpreadsheet action in a macro. You can use DoCmd.TransferSpreadsheet
action in VBA code. I have lots of VBA examples on my web page:

http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm
 
Back
Top