Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Sat Sep 10 11:30:02 CDT 2005
Well, it's just a little division up near Portland that's developing NICs. But still... Rocky ----- 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 9:20 AM Subject: Re: [AccessD] Importing Multple Excel Worksheets > >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 > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >