Importing from Access to Excel

[WxShady13]

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

 

[WxShady13]

 

[Micron]

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]

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]

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]

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.

 

[Micron]

NP. Hope it helped somewhat.