[AccessD] Importing Multple Excel Worksheets

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Sat Sep 10 11:01:34 CDT 2005


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
> 




More information about the AccessD mailing list