[AccessD] Importing Multple Excel Worksheets

..are you still in touch with Andrei? ...iirc this is right up his alley..

William

----- Original Message ----- 
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
To: <AccessD at databaseadvisors.com>
Sent: Saturday, September 10, 2005 10:41 AM
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
>