Can I import excel spreadsheets into access?

A

Amos33

i am a new user and am wondering if this can be done?...and how easy is it?

Thank you:)
 
K

Ken Snell MVP

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Email notifications without opening application 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Access Lock File .LACCDB / Now shows as a notepad file 0
How can the font and size of (all) citation numbers be altered? 1
Booklet in Word, Merge Directory from Excel 0
Word macro that can call cells out of Excel for a find and replace 0
Merging from an Excel file with graphics 1

Top