[AccessD] Importing Multple Excel Worksheets

We haven't communicated in a long time.  But Colby's automation templates 
will probably do it.

Rocky

----- Original Message ----- 
From: "William Hindman" <dejpolsys at hotmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Saturday, September 10, 2005 8:51 AM
Subject: Re: [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
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>