Re: Access to dbf from Excel (ODBC problem)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Anders Altberg (x_pragma_at_telia.com)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 13:02:35 +0200

Hi
You should not use the default name "Visual FoxPro Tables". Rename the DSN.
It won't make difference, just be more as intended and let you create more
appropriately DSNs using this driver.
If the tables are link to a DBC metadatafile you should use the option
'Visual FxoPrp Database' instead.
No DSN using the VFP ODBC driver will work with VFP7 or later versions of
VFP where the tables use new data field types or database features. As of
VFP7 an OLE DB driver, VFPOLEDB.DLL is delivered with the product. The
latest version is actually trhe one included with the free public beta of
VFP9 that you can download from http://msdn.microsoft.com/vfoxpro
-Anders
MS VFP MVP

"Frank Dreyfus" <fdreyfus@nyw.com> wrote in message
news:Xns950BE37766A64adfslur0mdoaur03jadl@207.46.248.16...
> Hi,
>
> When trying to import a dbf into Excel 2003 (using Data/Import...) I get
> "Unexpected error from external database driver (8961)."
>
> I dl'd and installed the latest vfp odbc drivers and now have version
> 6.01.8629.01.
>
> Yet, when I try to import using the older "DBase Files (*.dbf)" driver I
> get the same error.
>
> The installation of the new vfp driver set up a System DSN called
> "Visual Foxpro Tables". But that dsn doesn't appear in Excel.
>
> I finally realized that instead of Data/Import, File/Open worked fine
> even though using the older "DBase Files (*.dbf)" driver.
>
> But shouldn't Data/Import work as well? How do I get the new driver to
> show up as a file type in Excel?
>
> Thanks, Frank
>
>

Relevant Pages

  • ODBC - The Connection Process
    ... I get a lot of queries to my personal/CPAN email address with connection ... Applications link to an ODBC Driver Manager and some of the driver ... ODBC Driver to load and pass information to the ODBC Driver to enable ... A DSN is a way of defining various attributes for an ODBC ...
    (perl.dbi.users)
  • Re: Help with Insertdatabase command
    ... When I go into ODBC Data Source Administrator and set up a User DSN, ... the firebird driver I get quite a detailed window headed 'Firebird ODBC Set ... In contrast when i add a File DSN after selecting firebird and then a name ...
    (microsoft.public.word.vba.general)
  • RE: [dbi] DSNs and DRIVER attribute
    ... It fixed all my DSN not found errors. ... the DRIVER attribute. ... > where mydsn is an entry in your unixODBC odbc.ini file defining host, ... >> series of connectivity tests that you can run after running 'make' ...
    (perl.dbi.users)
  • Eureka!
    ... fils dsn, and then connecting througe Excel/MSQuery which seemed to work. ... the firebird driver I get quite a detailed window headed 'Firebird ODBC ... Up which asks for datbase name, driver, client, database account, password ... 'When you click finish you will create the data source which you have just ...
    (microsoft.public.word.vba.general)