[AccessD] ODBC Problems - resending

 There is more than one way to skin a cat.

 If it is a really old FoxPro system ODBC
 might not work because the software hooks
 are just not there for such an old system.

 Older forms of access can import Foxpro
 in native mode.  Sometimes Foxpro can
 export to a spreadsheet or text file,
 but that might cause other problems.

 I recently had to convert data from
 very old mini-computers.  One system
 I converted everything to text files
 and did lots of slicing and dicing.

 Another was to get data from RDB into
 Orcale then into access.  On and on.

 There is more than one way to skin a cat.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Debbie Elam
Sent: Sunday, May 04, 2008 8:06 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] ODBC Problems - resending


I got the ODBC set up for Foxpro I think.  For some reason, I can no longer
connect to any ODBC data source in Access and my attempts to fix it have
failed.

Debbie Elam
214-437-6285


-----Original Message-----
From: Jack and Pat <drawbridgej at sympatico.ca>
Sent: Sunday, May 04, 2008 9:49 AM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] ODBC Problems - resending

Attachment got dropped so here is the text.

Jack
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Tuesday, May 16, 2006 2:29 PM
To: Access Developers discussion and problem solving
Subject: Import Foxpro into Access

You cannot connect directly to FoxPro databases in Access 2003

http://support.microsoft.com/?kbid=824264

You maybe skipping this step

3. In the Administrative Tools window, double-click Data Sources (ODBC),
and then add a new ODBC data source for your FoxPro database or tables
by selecting the appropriate Visual FoxPro driver.

Rocky Smolin - Beach Access Software wrote:

>Dear List:
>
>I've got a bunch of FoxPro dbf files and their corresponding CDX files
>I'm trying to link or import into an access database. In the import
>there are dbase 'files of type' but that doesn't work.  The import
>wizard looks for .ndx files which I think are the dbase index files.
>Has anyone done this before?
>
>MTIA,
>
>Rocky
>
>

-----Original Message-----
From: Jack and Pat [mailto:drawbridgej at sympatico.ca]
Sent: Sunday, May 04, 2008 6:45 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] ODBC Problems

Debbie,
I'm not a Foxpro user, but I did find a post from Marty that may be relevant
to you. Attached is his message.

jack


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie Elam
Sent: Saturday, May 03, 2008 8:05 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] ODBC Problems

I am trying to import data from a really ancient Foxpro database.  I was
creating an ODBC connection and got an error.  As the message suggested, I
reinstalled the Foxpro driver.  Now I get nothing when I try to connect to
any ODBC data source.  When I choose odBC the pop up just dissappears.  I
have tried reinstalling MDAC to no avail.  I have also bought a repair
utility that fails in the middle of working.  Any ideas on how to repair
this?

I am using Access 2003 and XP sp2.

Debbie Elam



[The entire original message is not included]

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com