[AccessD] Importing Multple Excel Worksheets

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Sat Sep 10 10:17:59 CDT 2005


D'oh.  Completely missed that.  Thanks.  This first test I'm just going to 
jam their data into an mdb with some queries.  Ultimately, I think I should 
use automation, though, so they can have a one-button solution.


Thanks,

Rocky

----- Original Message ----- 
From: "Susan Harkins" <ssharkins at bellsouth.net>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Saturday, September 10, 2005 8:04 AM
Subject: Re: [AccessD] Importing Multple Excel Worksheets


>
> 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.
>
> =========The Import wizard's very first pane should show two options: Show
> Worksheets and Show Ranges. You're not getting this?
>
> Susan H.
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list