[AccessD] Hide datasheet view of table when appending

Drew Wutka DWUTKA at Marlow.com
Thu Jun 12 20:04:14 CDT 2008


Have you tried using ADO to read the excel files and then dumping the
records?

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hewson, Jim 
Sent: Thursday, June 12, 2008 3:48 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Hide datasheet view of table when appending

I can't seem to figure this out....  
Access 2003
I am importing data from an Excel workbook to a table in Access.
All the worksheets will be imported and they have the same format.
The Excel files are created from a download from another system. 
The smallest workbook has 80 worksheets.  One test Excel file has about
2400 worksheets.
 
I am able to work on each worksheet, grab the desired range (could be 1
or 100 rows involved), paste it into Access, and close Excel.
I need to "hide" the table when the data is being appended.
What happens is the table is opened and the data is pasted into it -
everything shows in the database window.
 
How can I hid the table and still paste the data into it?
If I minimize it, I get an error message.
If I hide the table, I get an error message.
 
Any suggestions?
 
Thanks,
 
Jim
 
Jim H. Hewson 
 

########################################################################
########

This email transmission contains information from NCI Information
Systems, Inc. 
that may be considered privileged or confidential and is intended solely
for the 
named recipient.  If you have received this message in error, please
contact the 
sender immediately and be aware that the use, copying or dissemination
of this 
information is prohibited.

########################################################################
########
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.





More information about the AccessD mailing list