Covert Data in .DBF files to MS Sql

[pavanip]

Hi,

I am having database files in .dbf format.I am new to Foxpro database.Now i want to convert those foxpro database files to Sql server. Can you guide me is there any other tools to convert .Dbf files to Sql server(.mdf,.ld f).Its very urgent to me if you know please suggest me.


Thanks in Advance
Pavani

[ck9663]

Couple of options.

1. Convert it to CSV and upload it as CSV.

2. Use linkserver inside SQL Server.

3. Use OPENROWSET to access external database.

-- CK

[gpl]

In Enterprise Manager, under tools is Data Transformation Services; this allows you to import and export data in a huge number of formats .... visual foxpro is just one of them
Graham

[dmsoft]

Hi,

Look at http://dbconvert.com/convert-foxpro-...l-pro.php?DB=7

I hope it will help.