I am trying to use an excel workbook in my access 2013 database.
I like to use linked tables because I can update the excel workbook and the new data is available when I go into access.
The problem is an address field in excel only imports the first line of a 3 line address field. I have tried changing both access and excel formats and connections and only get the name no address or city state zip.
The field has wrap text alignment and I have taken that off and it all shows on one line but still only see name after linking or importing to table.
Help
Thanks,
Tina
I like to use linked tables because I can update the excel workbook and the new data is available when I go into access.
The problem is an address field in excel only imports the first line of a 3 line address field. I have tried changing both access and excel formats and connections and only get the name no address or city state zip.
The field has wrap text alignment and I have taken that off and it all shows on one line but still only see name after linking or importing to table.
Help
Thanks,
Tina