FoxPro linked into project (SQL Server)

  • Thread starter Thread starter Sander Verhagen
  • Start date Start date
S

Sander Verhagen

Hi,


I am having MSDE running on our file server.
I am using my laptop to work it, with an Access Database Project.
I would like to link (not import) data from our FoxPro based contacts list
system.
I have tried this in so terribly many ways I cannot even start to elaborate.
So please, someone, tell me how to go about on this, so that I can do a
fresh attempt, from scratch.

Thanks already,


Sander Verhagen
[ (e-mail address removed) ]
 
Hi,
You could try setting up your Foxpro database as a
linked server in SQL Server(MSDE). Then write a stored
proc to access the data you need using a fully qualified
naming syntax. Use the SP as the source of the data in
your .adp project.

HTH
Chris
 
Hi,


I got this to work by putting the FoxPro database on the same machine as
were MSDE is running. Sounds simple, eh ;-)

Gr.,


Sander Verhagen
[ (e-mail address removed) ]
 
Back
Top