William Hindman
dejpolsys at hotmail.com
Sat Sep 10 13:57:13 CDT 2005
..hey! ...I've got seven servers using Intel nics ...do they know its really Access? :) William ----- Original Message ----- From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Saturday, September 10, 2005 12:30 PM Subject: Re: [AccessD] Importing Multple Excel Worksheets > 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 >> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >