Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

more the one range with DoCmd.TransferSpreadsheet

Status
Not open for further replies.
Amir369

Amir369

Programmer
Jan 11, 2009
1
IL
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.

Any idea?
 
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
635
Andrzejek
Andrzejek
Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
349
Dan Stoica
Dan Stoica
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
329
Andrzejek
Andrzejek
JaineyBlue
  • Locked
  • Question
DLookup with criteria 1
Replies
2
Views
296
JaineyBlue
JaineyBlue

Part and Inventory Search

Sponsor

Back
Top