Visual Basic, ADO-VB6-Excel Conection

ADO-VB6-Excel Conection

Author	Message
CJ #1 / 3	ADO-VB6-Excel Conection How do you use ADO to connect to an Excel File and assign a field to a text box. on a form? Excel file is layed out in columns with headers at top of columns like an Acess File. I can do it with an Access file using OBDC drivers,conection string and SQL command, but that doesnt seem to work for an excel file. How do you do the same with a text file? Thanks CJK
Wed, 18 Jun 1902 08:00:00 GMT

Jean-George #2 / 3	ADO-VB6-Excel Conection I have an Excel file problem also. At the moment I am creating Excel file using .CSV in the file name and writing to it with a "write" command but I would like to create a real Excel file. I am using VB6 Thanks, Jean-Georges Quote: > How do you use ADO to connect to an Excel File and assign a field to a > text box. on a form? > Excel file is layed out in columns with headers at top of columns > like an Acess File. > I can do it with an Access file using OBDC drivers,conection string > and SQL command, but that doesnt seem to work for an excel file. > How do you do the same with a text file? > Thanks > CJK
Wed, 18 Jun 1902 08:00:00 GMT

RespMec #3 / 3	ADO-VB6-Excel Conection Hi, You might visit the Control Panel ODBC32 Icon and then create a DSN that links to the Excel file. Then this can be used to make an ADO Connection. Ranny Quote: > How do you use ADO to connect to an Excel File and assign a field to a > text box. on a form? > Excel file is layed out in columns with headers at top of columns > like an Acess File. > I can do it with an Access file using OBDC drivers,conection string > and SQL command, but that doesnt seem to work for an excel file. > How do you do the same with a text file? > Thanks > CJK
Wed, 18 Jun 1902 08:00:00 GMT

Page 1 of 1

[ 3 post ]