import information from excel to access

theYaniac

New Member
Joined
Jan 7, 2018
Messages
34
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?
 

theYaniac

New Member
Joined
Jan 7, 2018
Messages
34
positive, I copy and pasted values only on the excel sheet for a test run to link the two together
 

UncleCatwoman

New Member
Joined
Nov 3, 2016
Messages
35
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

New Member
Joined
Nov 3, 2016
Messages
35
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

New Member
Joined
Jan 7, 2018
Messages
34
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

New Member
Joined
Nov 3, 2016
Messages
35
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.
 

Forum statistics

Threads
1,086,220
Messages
5,388,540
Members
402,118
Latest member
Scott Hughson

Some videos you may like

This Week's Hot Topics

Top