subscript out of range

[philfer]

Hello,

When I try to import a sheet from Excel into an existing table I get a subscript out of range error.

When I then import the sheet into a new table and then import it into the existing table I was trying above immediately afterwards it works fine

What a mystery?!?!!?

Anyone ever seen anything like this before

Cheers​

 

[DavidAtWork]

I suspect there may be columns in your excel sheet that were deleted at some stage, but still recognised by the import wizard and as these don't exist in the existing table, it fails.
When you import it into a new table, does the wizard add additional columns which don't have any values in?

David

 

[heathb]

Hi, jumping on this oldie

Have a similar issue. Have an excel template that I have populated then imported and appended to a table twice. On the 3rd update (each update is a diff month of data) I am getting the Subscript out of range.

Quite a few ideas on here, however I am just doing this manually, not via code so do not really apply.

Is there a size limit at all?, so far I have 403550 rows and trying to import another 210568

Template limits the columns etc.

I have tried with a data file of 1 row, and still get the error..

Any help out there please

 

[heathb]

closed and reopen has worked ??????????