Transfer Spreadsheet not importing all data

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??
 
K

Ken Snell \(MVP\)

Post the code that you're using so we can see how you've set up the
arguments for TransferSpreadsheet.
 
T

Tiffany

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.
 
K

Ken Snell \(MVP\)

Try using the worksheet name in the Range argument -- the ! character must
remain:

Range = NameOfYourWorksheetGoesHere!A2:E65000
 
K

Ken Snell \(MVP\)

I don't understand the context of your reply. What did you try? What is the
name of the worksheet?
 
T

Tiffany

Hi,
I have put Sheet!A2:O65000 in the Range argument of the macro, and it still
only imports 253 rows of data.
 
K

Ken Snell \(MVP\)

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?
 
T

Tiffany

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.
 
Joined
May 11, 2011
Messages
1
Reaction score
0
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.
 

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

Top