|
Home > Archive > dBASE Questions and Answers > December 2005 > Connecting to Excel
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Connecting to Excel
|
|
| George Chow 2005-12-06, 1:23 pm |
| Hello:
I managed to use the dQuery wizard from dBase Plus v 2.21 to connect to an Access database table. Once thats done, I can then manipulate the data using dot commands, even in a program!
However, I did not find the same wizard prompts for Excel spread sheets.
I tried using the BDE administrator, was unsuccessful.
In both the BDE administration and dQuery, on click it, the login username, password window appears and can go no further.
there must be a way to manipulate excel spreadsheet data from dbase without doing an import/export, CSV file..etc.
any help appreciated.
George
| |
| Ken Mayer [dBVIPS] 2005-12-06, 8:25 pm |
| George Chow wrote:
> Hello:
> I managed to use the dQuery wizard from dBase Plus v 2.21 to connect to an Access database table. Once thats done, I can then manipulate the data using dot commands, even in a program!
> However, I did not find the same wizard prompts for Excel spread sheets.
>
> I tried using the BDE administrator, was unsuccessful.
> In both the BDE administration and dQuery, on click it, the login username, password window appears and can go no further.
>
> there must be a way to manipulate excel spreadsheet data from dbase without doing an import/export, CSV file..etc.
>
> any help appreciated.
It can be done, but not through dQuery. dQuery is designed to work with
tables, and despite all appearances, an Excel spreadsheet is not really
a table, at least not by the internal definitions used by dBASE and the BDE.
I would suggest that for some situations it is probably easier to export
the data from the spreadsheet to a table, then import it back to Excel ...
Otherwise you're going to have to write routines using OLE to get in
there and manipulate the spreadsheet -- not particularly an easy thing
to do.
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
|
|
|
|
|