more the one range with DoCmd.TransferSpreadsheet

A

amir369

Hi All,
I'm trying to import an Excel sheet, but with more the one rang, couse the
columns aint sequence.
for example:
DoCmd.TransferSpreadsheet acImport, , "DailyRprzntvRpt", _
Application.CurrentProject.Path & "\DailyRprzntvRpt.xls", True, "(A1:C18,
F1:J18)"

I'm getting an error, that saies that the range is not recognized by Access.

When I'd try to name a multiply rangs in Excel, Access didn't recognized
that name at all.

Any idea?
 

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

More the one range with DoCmd.TransferSpreadsheet 1
Importing multiple work sheets from a single excel Workbook 1
Possible to import a specific sheets data from excel into access? 1
Problem with DoCmd.TransferSpreadsheet acImport 4
how do I check if a field exists and create it if not? 0
Import Excel ranges - clarify 20
Importing Excel Sheet into Access Database using VBA 2
import excel using button 2

Top