importing excel data

G

Guest

Anyone know where I can find info on how to import excel spreadsheets with mutliple worksheets?
 
K

Ken Snell

What do you want to know? See TransferSpreadsheet in Help files for start.

--
Ken Snell
<MS ACCESS MVP>

dodge said:
Anyone know where I can find info on how to import excel spreadsheets with
Click to expand...
mutliple worksheets?
 
M

Matt Carver

Click File -> Get External Data -> Import...

In the file type change it to Excel.

Select your excel file and follow through the wizard.

dodge said:
Anyone know where I can find info on how to import excel spreadsheets with
Click to expand...
mutliple worksheets?
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Excel spreadsheets opening at top instead of bottom. 4
Excel Import External Data by Date Automatically 0
Access Subscript out of range when importing into access 2010 from excel 0
Import Excel to Acsess using Macro 3
Import Individual Rows of Excel Data 4
Excel Spreadsheets keep moving 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Top