I have an intermittent problem that I haven't been able to trace. I have an Access2002 database linked to an xls file. I update some of the fields in the xls file with data from a table. Periodically, some of the column data in the non-linked fields (manually entered) shifts over to the left from where it was originally. This is occurring with an update query. The query has nothing to do with the non-linked fields. The data shifts left and stops to the right of the first non-blank column. Has anyone experienced this or know what the problem might be? This one is very frustrating.
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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Link shifts spreadsheet data
- Thread starter kashew
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question