[AccessD] Importing Excel .csv to Access

Mark:

I often get this behaviour when running Excel 97 automation and I interrupt 
the Excel object clean up code while debugging Excel manipulation code.  
Once I shutdown the Access driver application, Excel opens clean again.  
This suggests to me that it happens when you fail to properly clean up Excel 
object variables.

If the Excel sheets come with code or are you using automation this may be 
worth a look.

Hen




>From: "Mitsules, Mark" <mitsules_ms at nns.com>
>Reply-To: accessd at databaseadvisors.com
>To: "'AccessD'" <AccessD at databaseadvisors.com>
>Subject: [AccessD] Importing Excel .csv to Access
>Date: Mon, 14 Apr 2003 09:45:29 -0400
>
>Group,
>
>I received several Excel files from a client for import, however, when I
>attempt to open the file, the only visible areas are the border and
>toolbars.  The desktop can be seen through the window.  I've found that if 
>I
>toggle the "Full Screen" option in the pull down menus on and then off, the
>Excel display returns to normal.  Can anyone explain this behavior, and
>offer a solution that will open the Excel window normally by default?
>
>
>
>Mark
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963