import information from excel to access

[theYaniac]

I am trying to import cost report information from an excel sheet to an access table. I have the fields in the access table matched exactly to the excel sheet i am trying to import from. However, the access import wizard is showing three additional fields that don't exist in my excel sheet. It keeps returning an error and will not import. The last column used in the excel sheet is column AE (resource class). Access import wizard is showing 3 fields to the left of this column. Any help or suggestions would be greatly appreciated.

PS Is there a way to attached snipped screen shots to this forum?

 

[sheetspread]

You're sure nothing's hidden?

 

[theYaniac]

positive, I copy and pasted values only on the excel sheet for a test run to link the two together

 

[UncleCatwoman]

I do a LOT of imports this way. What you also need to do is make sure the Excel columns are not active. Empty is not good enough. Highlight every column except the ones you're importing and Clear>All. That should do it for you.

 

[UncleCatwoman]

Also, if this is something you're going to be doing often, write code to do it (instead of using an import spec). You'll have a lot more control.

 

[theYaniac]

I have my cost reports set up in excel for each facility at the moment. I would like to eventually have everything in access. For the columns i n the excel sheet that perform all of my calculation, should I set up fields in access to now perform the calculations and only import the raw data from excel?

 

[UncleCatwoman]

If the data will always be coming into Access from Excel, I would build my calculations into the import process. If the data will all be entered into Access itself, then, depending on your processes and timelines, you can do it either with data entry or on a set schedule (i.e. calculating all the revenue from entered orders when you do invoicing). Whatever makes the most sense for what you have and need to do.