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.
Link or import into Access?
Started by
Guest_Marian_*
, Nov 20 2004 10:11 AM
6 replies to this topic
#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.
You need to use the free table driver and not the database container.
#3
jim bennett
-
- Members
-
- 5 posts
Newbie
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
-
- Moderators
-
- 101 posts
Advanced Member
- Gender:Male
- Location:ny
Posted 11 January 2005 - 10:15 PM
#5
MerchantSmurf
-
- Members
-
- 22 posts
Member
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.
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
-
- Members
-
- 92 posts
Advanced Member
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.
Will the drivers that come with Win2000 work?
Thanks.
#7
ypf1258
-
- Moderators
-
- 101 posts
Advanced Member
- 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.
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
