Excel Import Question

G

Guest

I currently have a spreadsheet that contains 31 tabs, one representing for
each day of the month. I want to import this spreadsheet into access, but I
want to be able to import all pages at one time without having to go one by
one.

Is there a way to do this?

Thank you
 
G

Guest

There is something called the "transferspreadsheet" method. If you look on
the import/export board you will find it.
 

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
Import Many Tabs from Many Spreadsheets 1
Excel Import External Data by Date Automatically 0
Access Subscript out of range when importing into access 2010 from excel 0
Import data from Access to Excel containing VB code 3
Import to many to many table 7
Import Excel Spreadsheet 1
Question on importing from Excel 3

Top