| View previous topic :: View next topic |
| Author |
Message |
John
Guest
|
 Posted: Fri May 21, 2004 6:04 pm Post subject: Is possible connect to Excel as TTable? |
 |
|
How can I easily connect to an excel table (can be read only)? I need to
extract all the data from a spreadsheet into another database - am doing
this now by importing the excel spreadsheet into MS Access - then connecting
via TTable within my application. Would love to get rid of that import step
and just connect directly to the spreadsheet.
thanks
|
|
| Back to top |
|
 |
Wayne Niddery [TeamB]
Guest
|
| Posted: Fri May 21, 2004 6:48 pm Post subject: Re: Is possible connect to Excel as TTable? |
|
|
John wrote:
| Quote: | How can I easily connect to an excel table (can be read only)? I need
to extract all the data from a spreadsheet into another database - am
doing this now by importing the excel spreadsheet into MS Access -
then connecting via TTable within my application. Would love to get
rid of that import step and just connect directly to the spreadsheet.
|
If you have Excel on your system then there should also already be an ODBC
driver for Excel that you can attach via the BDE and a TTable.
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: http://www.logicfundamentals.com/RADBooks.html
"True peace is not the absence of tension, but the presence of
justice." - Martin Luther King, Jr.
|
|
| Back to top |
|
|
Rick Carter
Guest
|
| Posted: Mon May 24, 2004 9:50 pm Post subject: Re: Is possible connect to Excel as TTable? |
|
|
| Quote: | How can I easily connect to an excel table (can be read only)? I need to
extract all the data from a spreadsheet into another database - am doing
this now by importing the excel spreadsheet into MS Access - then
connecting
via TTable within my application. Would love to get rid of that import
step
and just connect directly to the spreadsheet.
|
Yet another alternative would be to do a "save as" in Excel to save in
dBASE III+ or dBASE IV (.dbf) format. Then you could continue to edit
it directly in Excel, but you could also easily open it using the BDE or
any of a number of other database engines.
Rick Carter
[email]carterrk (AT) despammed (DOT) com[/email]
Chair, Delphi/Paradox SIG, Cincinnati PC Users Group
--- posted by geoForum on http://delphi.newswhat.com
|
|
| Back to top |
|
|
Mike Shkolnik
Guest
|
| Posted: Tue May 25, 2004 5:12 am Post subject: Re: Is possible connect to Excel as TTable? |
|
|
Rick,
| Quote: | Yet another alternative would be to do a "save as" in Excel to save in
dBASE III+ or dBASE IV (.dbf) format.
This way is good only for english characters. Problem that MS Excel use the |
old DOS encoding for dBase tables but 99% developers now uses the Windows
encoding (ANSI).
--
With best regards, Mike Shkolnik
E-mail: [email]mshkolnik (AT) scalabium (DOT) com[/email]
WEB: http://www.scalabium.com
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
