Transfer Spreadsheet not importing all data

  • Thread starter Thread starter Tiffany
  • Start date Start date
T

Tiffany

Hi there,

I am using the TransferSpreadsheet argument to import a spreadsheet.
The spreadsheet has data in the first row so in the range I use A2:O65000
(to capture everything). When I use this, it only imports 253 rows, but when
I go into the spreadsheet and delete the first row and take out the A2:O65000
in the Range, it imports everything. How can I get it import all what I want
by starting from row without having to go into the spreadsheet to delete the
first row??

Can someone pls help??
 
Post the code that you're using so we can see how you've set up the
arguments for TransferSpreadsheet.
 
I am using the TransferSpreadsheet Action in a macro (not VB code)
Transfer Type = Import
Spreadsheet Type = Microsoft Excel 8-10
Table Name = Act_Hrs_Ovt
File Name = =Get_FileName("Please select Act Hrs Ovt File to import", "Act
Hrs Ovt")
Has Field Names = Yes
Range = A2:E65000

This code is the same for 5 tables I am importing, the only difference is
the File Name and Range and Table Name.
 
Try using the worksheet name in the Range argument -- the ! character must
remain:

Range = NameOfYourWorksheetGoesHere!A2:E65000
 
I don't understand the context of your reply. What did you try? What is the
name of the worksheet?
 
Hi,
I have put Sheet!A2:O65000 in the Range argument of the macro, and it still
only imports 253 rows of data.
 
Is Sheet the actual name of your worksheet? How many rows of data are in the
EXCEL spreadsheet? Is the 254th row completely empty in the spreadsheet?
 
shee1 is the worksheet name, and no the 254th row isn't blank at all.
This happens with multiple imports on different files, some long and some
short files.
There are about 4000 rows in the spreadsheet i'm trying to import.
 
I have the same problem, tried fully qualifying the range to be imported with the sheet-name (i.e. sheet1!A2:M60000) but still only 253 rows were imported.

The only things that seems to work sometimes is editing and resaving the spreadsheet or leaving the spreadsheet open in Excel when I run the import macro.

I am interested if anyone else has encountered this problem in Access and if they found a solution to it.
 
Back
Top