Solved Excel workbook linked to Access 2013 not reading all text in cell (1 Viewer)

tinher

Registered User.
Local time
Today, 07:49
Joined
May 11, 2019
Messages
30
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
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 07:49
Joined
Aug 30, 2003
Messages
35,741
Shot in the dark, but expand the height of the row in the linked table. The other data may be on the next line(s).
 

tinher

Registered User.
Local time
Today, 07:49
Joined
May 11, 2019
Messages
30
Shot in the dark, but expand the height of the row in the linked table. The other data may be on the next line(s).
I tried that and it shows fine and even looks good when I import the table but after import the shipping address only has a name in it no address. Thank You for trying.
 

tinher

Registered User.
Local time
Today, 07:49
Joined
May 11, 2019
Messages
30
I tried that and it shows fine and even looks good when I import the table but after import the shipping address only has a name in it no address. Thank You for trying.

I went back and looked again and I think you fixed my problem.

I just have never seen access format data that way. It is perfect and I thought it was broke. I have never expanded a row height in an access table on forms yes. Lots of times in excel but never in access.

excel and access realize it is an address and formatted it accordingly.

Thank You so much.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 07:49
Joined
Aug 30, 2003
Messages
35,741
Happy to help! I got burned by that in the other direction. There was a second line that shouldn't have been there and I didn't notice it right off.
 

Users who are viewing this thread

Top Bottom