Re: strConnectionString and INSERT INTOThis is a discussion on Re: strConnectionString and INSERT INTO within the ODBC forums in Framework and Interface Programming category; On Thu, 18 Jan 2007 14:01:02 -0800, EKJ <EKJ @ discussions.microsoft.com> wrote: ¤ Hello ¤ ¤ I need to store some data in excel, but i need to store them in 3 different ¤ sheets ¤ how do i do that. Sheets in Excel are essentially equivalent to Tables in a database. When you perform the INSERT you simply specify the Sheet name in the statement. ExcelADO demonstrates how to use ADO to read and write data in Excel workbooks http://support.microsoft.com/kb/278973 Paul ~~~~ Microsoft MVP (Visual Basic)... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
01-19-2007, 09:15 AM
| |||
| |||
 Re: strConnectionString and INSERT INTO On Thu, 18 Jan 2007 14:01:02 -0800, EKJ <EKJ@discussions.microsoft.com> wrote: ¤ Hello ¤ ¤ I need to store some data in excel, but i need to store them in 3 different ¤ sheets ¤ how do i do that. Sheets in Excel are essentially equivalent to Tables in a database. When you perform the INSERT you simply specify the Sheet name in the statement. ExcelADO demonstrates how to use ADO to read and write data in Excel workbooks http://support.microsoft.com/kb/278973 Paul ~~~~ Microsoft MVP (Visual Basic)  |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 12:27 AM.
