If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2002 import wizard issue
Access 2002 SP3
When attempting to import from either an Excel spreadsheet or a CSV file the wizard fails to function properly. Everything works fine except the part where I tell the wizard which columns (fields) to import. The first column is automatically selected and I can choose to skip it or rename it just as you would expect. When I try to select any of the other columns they highlight properly but the the fieldname remains whatever was in column 1. If I rename it, it renames column 1 not the desired column. All the data will import fine, but I cannot skip any columns except the first. So the workaround is to import everything then delete from the table what I don't need later. BTW, same data files will import fine and behave correctly on another PC with Access 2002 without any SPs. Steps taken to resolve: Repaired Office XP. Removed Excel, Access, and Word and reinstalled them. Still behaves the same way. Makes me believe its a bug from one of the SPs. I slipstreamed the SPs into my Office install so I'd pretty much have to completely reinstall Office to remove them. Hoping someone else has seen this and knows of a file to replace or something simple. TIA |
#2
|
|||
|
|||
Access 2002 import wizard issue
Try it this way:
file / get external data / LINK tables (instead of import) Select the table(s) you want to link. Go to create query, use the table(s) you just linked, select the column(s) that you want, rename them using the a label. Then change your query to a Make Table Query. Give it a name and run it. May not be as elegant or efficient as import wizard but it works. -----Original Message----- Access 2002 SP3 When attempting to import from either an Excel spreadsheet or a CSV file the wizard fails to function properly. Everything works fine except the part where I tell the wizard which columns (fields) to import. The first column is automatically selected and I can choose to skip it or rename it just as you would expect. When I try to select any of the other columns they highlight properly but the the fieldname remains whatever was in column 1. If I rename it, it renames column 1 not the desired column. All the data will import fine, but I cannot skip any columns except the first. So the workaround is to import everything then delete from the table what I don't need later. BTW, same data files will import fine and behave correctly on another PC with Access 2002 without any SPs. Steps taken to resolve: Repaired Office XP. Removed Excel, Access, and Word and reinstalled them. Still behaves the same way. Makes me believe its a bug from one of the SPs. I slipstreamed the SPs into my Office install so I'd pretty much have to completely reinstall Office to remove them. Hoping someone else has seen this and knows of a file to replace or something simple. TIA . |
#3
|
|||
|
|||
Access 2002 import wizard issue
Hi, I have exactly the same behaviour. Our desktops are XP Sp1 and Office 2k Sp3. (Multilingual) The bug appeared after deploying Sp3. I will do further testing, but I think that the SP3 has a lot of bugs... I already had to restore a SP1 dll to correct a dictionnary bug in Office. If you look at http://support.microsoft.com/?id=837003 , you will find something similar for Access 2003. I tried this patch but it doesn't work with Access 2002. Still searching... Michel Cato wrote: *Access 2002 SP3 When attempting to import from either an Excel spreadsheet or a CSV file the wizard fails to function properly. Everything works fine except the part where I tell the wizard which columns (fields) to import. The first column is automatically selected and I can choose to skip it or rename it just as you would expect. When I try to select any of the other columns they highlight properly but the the fieldname remains whatever was in column 1. If I rename it, it renames column 1 not the desired column. All the data will import fine, but I cannot skip any columns except the first. So the workaround is to import everything then delete from the table what I don't need later. BTW, same data files will import fine and behave correctly on another PC with Access 2002 without any SPs. Steps taken to resolve: Repaired Office XP. Removed Excel, Access, and Word and reinstalled them. Still behaves the same way. Makes me believe its a bug from one of the SPs. I slipstreamed the SPs into my Office install so I'd pretty much have to completely reinstall Office to remove them. Hoping someone else has seen this and knows of a file to replace or something simple. TIA * -- McKlee ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message766678.html |
#4
|
|||
|
|||
Access 2002 import wizard issue
Hi again ! I think I have the solution. 1° Close Access 2002 2° Goto C:\Program Files\Microsoft Office\Office10\ and locate ACCWIZ.DLL. Rename it to *.old 3° Copy this Dll from a working workstation (with no Office SP)and paste it in C:\Program Files\Microsoft Office\Office10\ 4° Restart Access and Try ! It should now work again... (it worked for me) Hope this post helps. Michel -- McKlee ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message766678.html |
Thread Tools | |
Display Modes | |
|
|