Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

I should connect a Excel Sheet as OLEDB

8 views
Skip to first unread message

Toni18

unread,
Apr 3, 2009, 4:08:16 PM4/3/09
to
When i defined te connection in the frame:
PROFILE NAME: ROL
PROVIDER: Microsoft.Jet.OLEDB.4.0
DATA SOURCE: c:\l1.txt
EXTENDED PROPERTIES: Excel 5.0

But, i test the connection. I hav a erre:
SQLSTATE = 3343
Microsoft JET Database engine
Unrecognized database format 'X:\l1.TXT'

The connection stream is:
// Profile ROL
SQLCA.DBMS = "OLE DB"
SQLCA.AutoCommit = False
SQLCA.DBParm =
"PROVIDER='Microsoft.Jet.OLEDB.4.0',DATASOURCE='X:\L1.TXT'"

Please, Helpme

Toni18

unread,
Apr 3, 2009, 4:15:32 PM4/3/09
to
When i defined te connection in the frame:
PROFILE NAME: ROL
PROVIDER: Microsoft.Jet.OLEDB.4.0
DATA SOURCE: c:\l1.xls
EXTENDED PROPERTIES: Excel 5.0

But, i test the connection. I hav a erre:
SQLSTATE = 3343
Microsoft JET Database engine

Unrecognized database format 'X:\l1.xls'

The connection stream is:
// Profile ROL
SQLCA.DBMS = "OLE DB"
SQLCA.AutoCommit = False
SQLCA.DBParm =
"PROVIDER='Microsoft.Jet.OLEDB.4.0'

,DATASOURCE='X:\L1.XLS'"

Please, Helpme

0 new messages