Import data to SQL server

[cberam]

Hi, I have a foxpro dbf file and I want to copy the data from mdf to sql server, how can I ? I have tried through the sql server Import wizard but failed to do this....Pls help Thanks Ram

[phokojoe]

Try the Data Transformation Services import/Export wizard of the sql server and choose the correct data source. Does it work!:) phokojoe

[Vasudevan Deepak Kumar]

Hi Ram: By 'Import Wizard', did you mean DTSWiz (Data Transformation Services Wizard) with SQLServer. What is the error that you are encountering along? Deepak Kumar Vasudevan Personal Web: http://vdeepakkumar.netfirms.com/ I Blog At: http://deepak.blogdrive.com/