[AccessD] Connecting To Excel via Code (module)

Golly Gosh. That's such a great piece of example code <vbg>

> -----Original Message-----
> From:	Drew Wutka [SMTP:DWUTKA at marlow.com]
> Sent:	Monday, November 03, 2003 12:05 PM
> To:	'Access Developers discussion and problem solving'
> Subject:	RE: [AccessD] Connecting To Excel via Code (module)
> 
> Use ADO.  It will let you treat Excel just like any other recordset.  
> 
> Drew
> 
> -----Original Message-----
> From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net]
> Sent: Monday, November 03, 2003 9:18 AM
> To: accessd
> Subject: [AccessD] Connecting To Excel via Code (module)
> 
> 
> To all,
> We are operating Office XP Professional and I have started to write a
> little
> scheduling application.  Every so often we will have an Excel Workbook
> containing three spreadsheets, what I need to be able to do is link into
> the
> Workbook to bring a certain clients data in from the second sheet.
> The fields in the workbook are as follows:
> StoreNo, HolidayWeek, Sun, Mon, Tue, Wed, Thur, Fri, Sat
> StoreNo contain the store number and if there is a certain week that we
> cannot go to the store the week commencing date wil be entered under
> HolidayWeek.  If there is a certain day or multiple days that we cannot go
> to the store, the individual dates will be stored under the day of the
> week.
> Now I have a tbale with the following fields :
> StoreNo, BlackoutWeek, BlackoutDay
> I need to link into Excel and bring the data in from the Excel spreadsheet
> into the table above.
> So I may end up with
> StoreNo            BlackoutWeek             BlackoutDay
> 1                                                              27/01/04
> 1                                                              28/01/04
> 1                          04/01/04
> etc, has anyone any sample code on how to link into the Excel spreadsheet
> an
> retrieve the data.
> Thanks in advance for any help.
> Paul Hartland
> _______________________________________________
> 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