Hewson, Jim
JHewson at nciinc.com
Thu Jun 12 16:40:12 CDT 2008
Thanks, I tried that, but I kept getting an error when I defined the range to transfer. One range might be A4:S4 The next range might be A4:S30 The DoCmd.TransferSpreadsheet gave me an error when I tried to use variables in the range. How can I make it work? Jim jhewson at nciinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Thursday, June 12, 2008 3:59 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Hide datasheet view of table when appending I'd suggest you stop using copy and paste and consider using the DoCmd.TransferSpreadsheet method. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hewson, Jim Sent: Thursday, June 12, 2008 4: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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ################################################################################ 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. ################################################################################