TransfereSpeadSheet import?

N

Niklas Östergren

Hi!

Is it possible to select which sheet on a spreadsheet to import with
DoCmd.SpreadSheet?

If so then I might be able to use this to seperate in which table data from
our website shall go.

TIA!
// Niklas
 
N

Nikos Yannacopoulos

Niklas,

Use the Range argument of TransferSpreadsheet for the worksheet name.

HTH,
Nikos
 
N

Niklas Ostergren

OK!

So how do I specify a complete sheet do I use "Sheet 1" and "Sheet 2" or
what ever string name the sheet have, or?

Thank´s for helping out!
// Niklas
 
N

Nikos Yannacopoulos

Exactly!

Niklas said:
OK!

So how do I specify a complete sheet do I use "Sheet 1" and "Sheet 2" or
what ever string name the sheet have, or?

Thank´s for helping out!
// Niklas
Click to expand...
 

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 a VBA subroutine 0
Embed the same Excel multiple times 0
Open a form while hiding Access DB interface. 1
Creating a Chart on form from selected data in query. 0
Is it possible to import text from an e-mail? 0
Table Security in Access 2013 1
Import to many to many table 7
Replacing a Table with a Table from another database - reference issues 1

Top