Jump to content


Link or import into Access?


  • Please log in to reply
6 replies to this topic

#1 Guest_Marian_*

Guest_Marian_*
  • Guests

Posted 20 November 2004 - 10:11 AM

We use mom 5.1 and want to import or link tables to Access 2003 for reporting purposes. I can't seem to figure what the proper driver is to do this. I tried setting up a dsn using the latest Visual FoxPro ODBC driver, but it didn't seem to work. Any help greatly appreciated.

#2 Guest_Harry_*

Guest_Harry_*
  • Guests

Posted 21 November 2004 - 09:09 PM

Hello,

You need to use the free table driver and not the database container.

#3 jim bennett

jim bennett

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 24 November 2004 - 01:20 PM

I am still using Access 97, but I link copies of Mom's dbf files directly to Access. Most of my reporting is then done through Access.

#4 ypf1258

ypf1258

    Advanced Member

  • Moderators
  • PipPipPip
  • 101 posts
  • Gender:Male
  • Location:ny

Posted 11 January 2005 - 10:15 PM

follow the link to download an updated driver & remember to select free table dir.
vfox pro driver

#5 MerchantSmurf

MerchantSmurf

    Member

  • Members
  • PipPip
  • 22 posts

Posted 27 January 2005 - 10:47 AM

To add to this....

I was not able to open the MOM database with Access 2002 until I deleted a DBF file in the folder.
There is a file that is ".DBF", with no name. This was causing an error.

Once that was deleted, everything went smoothly.

I am not sure what this table does, if anything.
I would test with a copy and not go deleting things out of the live version. :)

#6 johnay

johnay

    Advanced Member

  • Members
  • PipPipPip
  • 92 posts

Posted 08 September 2005 - 04:58 AM

vpf1258: When I tried the link I got "The Knowledge Base (KB) Article You Requested Is Currently Not Available"

Will the drivers that come with Win2000 work?

Thanks.

#7 ypf1258

ypf1258

    Advanced Member

  • Moderators
  • PipPipPip
  • 101 posts
  • Gender:Male
  • Location:ny

Posted 08 September 2005 - 04:31 PM

vpf1258: When I tried the link I got "The Knowledge Base (KB) Article You Requested Is Currently Not Available"

Will the drivers that come with Win2000 work?

Thanks.

View Post



I have fished it out again on microsoft website Fox pro driver




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users