Billy Pang
tuxedo_man at hotmail.com
Wed Apr 5 13:56:47 CDT 2006
Eureka! Thanks Marty. I think the problem is MS Access 2k3 running without any SPs. This threw me off because I had MS Office 2003 Standard SP2 installed (MS Access 2k3 was installed separately a few weeks apart than MS Office 2003); I was working in Excel so when I looked under Excel's Program Info and saw SP2, I assumed it was likewise for Access. I was going to reinstall MDAC2.8 but saw that it doesn't touch Jet anymore. Anyhow I am going to try reapply Office 2k3 SP2. Hope that things will go smoothly. Thanks again for the insight! Billy >From: MartyConnelly <martyconnelly at shaw.ca> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >Subject: Re: [AccessD] MS Access 2003 -- keeps crashing on import >Date: Wed, 05 Apr 2006 10:45:17 -0700 > >It looks like you are running Office 2003 basic no SP's >WinXP SP2 installs a update to MDAC 2.8 >Also check if running latest Jet SP 8 > >Try installing Office 2003 SP1 >NOTE the SP2 removes ability to do automatic updating of linked Excel files >due to a patent restriction, so you may not want to install that version. > >How to check the version of Office 2003 products >http://support.microsoft.com/kb/821549 > >Office 2003 Service Pack 1 download >http://www.microsoft.com/downloads/details.aspx?FamilyId=9C51D3A6-7CB1-4F61-837E-5F938254FC47&displaylang=en > > >Office 2003 SP1 fixes this which maybe your problem > >http://support.microsoft.com/kb/837003/ >" When you use the Import Spreadsheet Wizard in Microsoft Access or the >Import Text Wizard in Microsoft Access to import a Microsoft Excel file >or a text file, you can modify the field information for only the first >field that is on the fourth page of the Import Spreadsheet Wizard or the >Import Text Wizard.ReasonThe problem is related to both the Import >Spreadsheet Wizard and the Import Text Wizard. > > >Billy Pang wrote: > > >Hello: > > > >I'm running MS Access 2003 on Windows XP SP2. > > > >When I try to import an Excel spreadsheet into an MS Access database, MS > >Access crashes. It doesn't matter whether destination database is in >Access > >2k or 2003 format. The following information is found in the event log. > > > >Faulting application msaccess.exe, version 11.0.5614.0, stamp 3f3c8e3c, > >faulting module unknown, version 0.0.0.0, stamp 00000000, debug? 0, fault > >address 0x00000000. > > > >I've tried searching the web for this error and found that some other >people > >also have the same problem (however not during an import but from other > >tasks such as creating a new report or viewing a form). > > > >Can anyone shed some light on this situation? Has this happened to >anyone > >else before? > > > >Many thanks in advance, > > > >Billy > > > > > > > > > >-- >Marty Connelly >Victoria, B.C. >Canada > > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com