i want to import excel data to access but

G

Guest

i want to import data from excel to access but only one spreadsheet is
imported i want to import 3 worksheets of a workbook what should i do
it only shows one worksheet
regards
 
D

Douglas J. Steele

The first page of the Import Spreadsheet Wizard should be showing you a list
of what worksheets exist in the workbook. You also have the chance to see
what named ranges exist. Do you not get this?
 

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

import multiple Excel worksheet into a main Access table 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import data from Access to Excel containing VB code 3
Importing data from Excel 2
Browse button for access form 1
Import Excel comments to field in Access 1
Importing from Excel - error when adding to existing table 6
Import to many to many table 7

Top