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