Doug Murphy
dw-murphy at cox.net
Sat Sep 10 11:54:13 CDT 2005
Rocky, If the spreadsheet has a fixed format you can do this with queries. I have an app that a customer uses for this very purpose. I have it set up with the file explorer dialog so they can point to the file and bring their data into a temp table where we do some sanity checks on the data and then parse it out to the appropriate tables through some more queries. If your interested let me know off line and I'll see if I can pull out the query and dialog part and send over. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - Beach Access Software Sent: Saturday, September 10, 2005 7:41 AM To: AccessD at databaseadvisors.com Subject: [AccessD] Importing Multple Excel Worksheets Dear List: I need to convert client data on a regular basis from an Excel workbook containing five worksheets. I need to link or import the sheets separately, of course, but neither the link wizard nor the import wizard seem to allow you to specify the worksheet. Is there a simple way to do this? The user is sophisticated and can do the manual link or import procedure. OTOH, if I did it through code I could give them a form with an 'Import It' button and it would be a one click operation. I have had problems with TransferSpreadsheet in the past, though. MTIA, Rocky Smolin Beach Access Software http://www.e-z-mrp.com 858-259-4334 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com