Importing from Access to Excel

WxShady13

Board Regular
Joined
Jul 24, 2018
Messages
100
I have connected my Access DB to an Excel file and all works perfectly except it does not bring in my 2nd column. It uses my first column as the default numbering format (ex. 1,2,3,etc) and then skips the 2nd and all others are correct. How can I get it to pull in the columns just like in the Access DB?

ParentID should be a name, ID should be the ParentID
 
Last edited:

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
1,855
If by "connected" you mean you imported a sheet into Access as a linked table, then I have no idea as I've never seen that, although I can't recall if I've ever done that where a sheet had any hidden columns. If "connected" means something else, state how because I think that will be important.
 

WxShady13

Board Regular
Joined
Jul 24, 2018
Messages
100
Yes I imported it and on the DB form the field is not hidden. The only thing I can think of is that the field is a drop down in Access so I didn't know if that would cause it not to pull in.
 

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
1,855
I mentioned that the sheet column might be hidden, not something on a form.
Now I suspect that your combo is based on a table field where you have made that field a lookup field in the table itself. AFAIK, you cannot import into a lookup field in a table. Just one of several reasons why experienced developers don't use them. Or the field in question is a multi value field, in which case the same comment applies.
 

WxShady13

Board Regular
Joined
Jul 24, 2018
Messages
100
Thank you for the information. I just imported the Payment table and the Parent Info table and did a vlookup to resolve the ParentID. It will work for what I need and build an easier front end for the clerk. Again I am very grateful for your time and information.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,562
Messages
5,487,578
Members
407,605
Latest member
PACULA

This Week's Hot Topics

Top