Appending excel sheets into access table

[al8876]

Hi!



Another really simple question I cannot seem to get!

Any help is greatly appreciated!

I'm having trouble appending an excel sheet into my access table.

I have 8 columns in my excel sheet:

1- full_name (short text)
2- alias (short text)
3- email_address (short text)
4- user_ID (short text)
5- Location (which is annotated using numbers 1,2,3,4 etc.) (number)
6- active (yes/no)
7- TRI (yes/no)
8- Another user ID (Short text form)

I am trying to append this data to an existing table in excel with the EXACT same column names.

I can append each column from my excel sheet separately and they will appear on the access table, but once I try to append all of the columns at the same time, so the records are not placed in different rows, I get a message saying "Script out of Range"

I cannot seem to figure it out since they can be uploaded individually.

Just to clarify, the excel columns are formatted to the access columns.

Thanks!

[June7]

What method are you using? Post code.

[al8876]

I am just going to "External Data" clicking on "Excel", and then "Append a copy of the records to the table"

Cheers!

[June7]

Can't help much without code to analyze. Would have to examine and test your data.

Well, maybe this is related to issue - is there an autonumber field in the table?

[al8876]

Thanks for the help! I was able to upload the data in a very unconventional matter, but it still worked!

I was able to import the data into a new table in access, where I then exported that data into excel, and then re-imported that data into the original table I had tried to upload the original data into. It's a bit of a pain but it works!