Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked or Imported Excel table doesn't look right

Status
Not open for further replies.

HomeALone

Instructor
Jul 20, 2001
110
US
One table in my Access database is used linked to an Excel spreadsheet on the network. The Excel spreadsheet is updated by another department. Today, the linked table doesn't display the information exactly except the one date field. Every other fields display only one or two characters that become unusable. I tried to re-link and re-omport the table but got the same results. Anybody knows why? I know my network guy is currently working on the network. Thanks!

 
OK, any body can shred some lights on this problem. I am still scratching my head real hard here!
 
OK, I got it figured out. The Excel Spreadsheet was re-formated again. That fixed the problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top