Importing a xls into Access

  • Thread starter Thread starter News.Microsoft.com
  • Start date Start date
N

News.Microsoft.com

How do I indicate in a macro that I want to import a particular sheet?
Example the .xls file has 4 sheets.

Bill
 
You might ask the folks in one of the Excel newsgroups.

HTH
 
Why? The macro is in Access and the I want to import the xls into Access.
This should be an Access question not an Excel question.

Bill
 
Sorry about that. I only look at the subject line to see if I want to
read the post. Once in the post the subject line is forgotten.

A macro in Access is an ugly thing. VBA is the preferred way to get
things done. You might look in help for TransferSpreasheet.

HTH
 
News.Microsoft.com said:
How do I indicate in a macro that I want to import a particular sheet?
Example the .xls file has 4 sheets.

Bill
Click to expand...

Dont know if you've gotten an answer yet, but this may work.
TransferSpreadsheet works for this on export, never used for import
though. Should work the same. Fill in all info and in the range field
- SheetName!StartRange:EndRange (A1:G15000).
Hope this helps.
 
You must log in or register to reply here.

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

Convert a csv to xls prior to import 2
Import Date Headings 6
Importing .xls into access and losing field values that contain al 3
Query csv, txt, xls 1
Import from Notepad delimited text 7
How to cause a spreadsheet (Excel) to run from an Access Macro 4
importing xls with dates 2
Output query to excel 1

Back
Top