These might help:
Did your IT department upgrade the windows operating systems? Not that I know that that would do anything… but just wondering if something between OS and apps is different now.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, August 19, 2015 11:14 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Strange Issue when importing from excel.
I have a database in access 03 format, but we use access 07 to run it. This database imports files from excel and then runs reports. It worked fine for YEARS, and I have made NO changes to it. However, last month, 2 of the excel files stopped importing (the other 30+ still work fine). I checked and the files haven't changed either (these two files contain different columns from each other, and are different from the rest of the files that import, although the other 30 files are essentially two files split into 15 divisions each).
When an excel file is selected for import, access opens the file and runs some code to remove excess columns and formatting, then they are transferred to a "holding" table in access that matches their respective columns, then appended to the "real" tables. However, the last two months, despite going through the formatting routine to remove the unwanted columns, I'm ge! tting an error saying "Column A does not exist in your table" when the transferspreadsheet command runs, but if you look at the spreadsheet file, Column A isn't there because it was deleted during formatting. If you step through the formatting routine, you can watch it delete Column A. Again, I have made NO changes to the database, and the source file appears to be the same.
I'm able to manually do an import on one of the two files (using "external data" tab and selecting excel) into the existing table as though nothing is wrong. Everything works fine if I do it that way, but it won't work via code, even though it's the same file.
The second file gives a "subscript out of range" error if I try to import it manually to the existing table. However if I import to a new table, then make an append query onto the table it was supposed to import to in the first place, it works fine.
A! s I said before, as far as I know the file has not changed. However to test the issue I tried to re-import 6 files that previously imported just fine, and those files no longer import either. Again, I have made NO CHANGES to the database, and these are files that imported successfully 3-9 months ago.
To eliminate corruption as the cause I have tried using different copies of the database (IE new database, then import all the objects). I've imported into new databases using different source databases to make sure that none of the versions I was importing from was corrupt. I've tried changing the format to access 07 (.accde and .accdb), I've used my dev version, test versions, production versions. NOTHING imports these two files anymore, despite the fact that I have made NO changes to the database, and files that imported successfully a few months ago will no longer import.
My guess is something changed on our computers, but I wouldn'! t even know where to begin looking. Anyone have any ideas?
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar