 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Tiberiu Horvath
Guest
|
 Posted: Thu Mar 29, 2007 8:11 am Post subject: ODBC |
 |
|
Hi all,
TD2006,
I am trying to import data from an Excel file, with OBDC.
My ODBC connection uses an Excel 97 driver (Administrative Tools, ODBC, etc)
and, in my program I try to mantain an ADOConnection and an ADOTable :
object ADOConnection1: TADOConnection
ConnectionString =
'Provider=MSDASQL.1;Persist Security Info=False;Data Source=impor' +
't excel;Mode=ReadWrite;Initial Catalog=C:\TEMP\KEBO'
CursorLocation = clUseServer
Mode = cmReadWrite
Provider = 'MSDASQL.1'
Left = 352
Top = 104
end
object ADOTable1: TADOTable
Connection = ADOConnection1
TableDirect = True
Left = 512
Top = 96
end
In the ADOTable.TableName instance field I am supposed to get the names of
the Spreadsheets from the Excel Workbook. But I get none so my data import
does not work.
Any ideas ?
Tiberiu
--------------------------------------------------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 2841 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now! |
|
| Back to top |
|
 |
Bill Todd
Guest
|
| Posted: Thu Mar 29, 2007 8:55 pm Post subject: Re: ODBC |
|
|
Tiberiu Horvath wrote:
Since your question is about ADO you will almost certainly get a better
answer if you post in the ADO newsgroup.
--
Bill Todd (TeamB) |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
