[AccessD] Importing Multple Excel Worksheets

John W. Colby jwcolby at colbyconsulting.com
Sat Sep 10 11:20:29 CDT 2005


>What they're doing, just BTW, is taking a snapshot from the mainframe
system and importing it into E-Z-MRP for their weekly planning.

8-)  Intel using your software!

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----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 12:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Importing Multple Excel Worksheets


John:

Yeah - already came across a sheet with a leading blank.  But I can get them

to standardize.  It's a division of Intel and they're pretty sharp.

I'll probably go with your automation template (usually do) and link 
directly to the spreadsheet so they don't have to do the import wizard 6 
times before they run the delete and append queries.

What they're doing, just BTW, is taking a snapshot from the mainframe system

and importing it into E-Z-MRP for their weekly planning.

Thanks and regards,

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334


----- Original Message ----- 
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Saturday, September 10, 2005 8:36 AM
Subject: Re: [AccessD] Importing Multple Excel Worksheets


> One of the things you need to be careful of is the naming of the 
> sheets inside of the workbook.  Often times the sheet name is whatever 
> the person exporting the data INTO excel wants to call it that day.  
> Even if the export to Excel is automated, the designer may do 
> something cute like name the sheet with date and/or time info.  When 
> you set up the link, the sheet name
> gets pulled into the link information.  If the sheet name changes, the 
> link
> fails.
>
> This can be worked around if the sheets are always in the same order, 
> then you use automation to open the work book, then go through the 
> sheets setting sheet one, two, three etc. to some fixed name YOU 
> decide (such as Sheet1, or
> CustomerData etc).  Close the workbook and now all of your sheets match 
> what
> the link expects and everything is fine.
>
> John W. Colby
> www.ColbyConsulting.com
>
> Contribute your unused CPU cycles to a good cause: 
> http://folding.stanford.edu/
>
> -----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 11:18 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Importing Multple Excel Worksheets
>
>
> 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
>>
>
> --
> 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
> 

-- 
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