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?
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?
"Chris Humphrey" <Chris [email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks