Subscript out of range. Import Error.

[John M.]

I have been designing a set of tables to accomodate data kept in excel and
other places. The tables are done and I exported the field names to make the
importing templates. I have been getting a series of error, the most serious
one being the "Subcript out of Range." when I have tried to Append the table
with an import. This shuts down the import and nothing comes in. I have
tried formatting the excel import file to match the field properties but no
luck changing the result.

 

[Jeanette Cunningham]

John,
there are quite a few things that can go wrong when importing from excel to
an existing access table.
I suggest to import to a new table and have a look at what happens.
You may find that there are extra fields in the new table that you don't
have in your existing table.
You may find that the data type for one or more fields is of a different
type than in your existing table.
Once you know all the differences you can either
--change your existing table to suit
--change the spreadsheet to suit
--import to a new table and then run an append query to get the data into
your existing table


Jeanette Cunningham -- Melbourne Victoria Australia

 

[John M.]

Good Suggestions. Thanks,
--
John M.

John,
there are quite a few things that can go wrong when importing from excel to
an existing access table.
I suggest to import to a new table and have a look at what happens.
You may find that there are extra fields in the new table that you don't
have in your existing table.
You may find that the data type for one or more fields is of a different
type than in your existing table.
Once you know all the differences you can either
--change your existing table to suit
--change the spreadsheet to suit
--import to a new table and then run an append query to get the data into
your existing table


Jeanette Cunningham -- Melbourne Victoria Australia