An ODBC add-in should be available for Excel 2003

[Guest]

Why isn't there an ODBC add-in for excel 2003 like there is in previous
versions, or are there any other methods available to query and import data
from a "DBF" file?

 

[Fredrik Wahlgren]

Why isn't there an ODBC add-in for excel 2003 like there is in previous
versions, or are there any other methods available to query and import data
from a "DBF" file?

You can use Data|Import external data. You have to create an ODBC connection
from Control Panel|Aministarive Tools|Data Sources (ODBC). You can also use
ODBC's successor, ADO, from VBA code.

/Fredrik

 

[Gerrit-Jan Linker]

If you like to use OLE DB or anything that works through ADO you can
use SQL*XL. I wrote SQL*XL to make working with databases from Excel
easier. It can load data into the database or load database data into
Excel. Insert and update forms can be created. Use of Excel cells as
parameters. VBA support. Multiple statements can be executed...

Perhaps you like to take a look at SQL*XL: http://www.oraxcel.com

Hope this helps,

Gerrit-Jan Linker
Linker IT Software
www.oraxcel.com