| Author |
Topic |
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
 Posted - 2009-01-22 : 03:30:14
|
| Hi I Just Want to Import data in Sql 2005 from Foxpro database and i m unable to do this....Please if any body know how to do this then lEt Me Knoe,,,,I just want it to do from Import\Export package....so any help will be Appreciated...Thnaks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-01-22 : 06:01:35
|
| Sorry still cant get it ......m unable to do this?Help me out in this,,,,I just make a plan to switch my Server 2000 From Sql 2005 But I am stuck in this? Becouse On Daily Basis there are several files to upload on Server so How to Upload FoxPro Data file in Sql 2005 thanks.....Thanks For your reply Sir...But please can u explain more this for me? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-22 : 06:52:45
|
Read Books Online how to create LINKED SERVER, and use the informaton in the provided links to successfully create a linked server to a FoxPro file.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
evmisu
Starting Member
17 Posts |
Posted - 2009-01-22 : 06:58:30
|
| SEE This and download the progarm for updating SQL Server: http://msdn.microsoft.com/zh-cn/vfoxpro/bb190232(en-us).aspxhope it is helpful. Andy |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-01-22 : 07:11:16
|
quote:
Originally posted by Peso
Read Books Online how to create LINKED SERVER, and use the informaton in the provided links to successfully create a linked server to a FoxPro file.
E 12°55'05.63"N 56°04'39.26"
Well I know How to create a linked server,,,,,i have a linked server on my Server but it is in Sql but i jus donn knw wat to do wid FoxPro,Well Thanks For Suggesstion |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-22 : 07:38:44
|
The very same thing. Just choose a FoxPro as datasource instead of another SQL Server.The provided link will tell you all details.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-01-22 : 08:33:15
|
| Ohkk I do only this for adding i linked server on My Instance.......like this,,,,EXEC sp_addlinkedserver @server='Tech1_instance1', @srvproduct='',@provider='SQLNCLI', @datasrc='TECH1\SQLEXPRESS'Select * from openquery(Tech1_instance1,'select custid from testtable')soi donn know how to do this for Foxpro....well one more thing when i tried to Export Data from Dts IMport\Export which is in SQL 2000 den it give error for SQL 2005 when i run it says,,,,Not A trusted Connection,,,i Only i just do something wrong with the Logins and roles ,,,,But Still cant find it out wat,,,So Any suggetions on this?Thanks,,,for replies |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-22 : 09:24:04
|
You connect FROM your SQL Server database TO the FoxPro file.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-01-22 : 11:39:36
|
| Right click on the database you want to import TO.A window coes that says SQL Server Import and Export WizardClick NextFor Data Source select nie that says FoxProSpecify File location and user name and password if necessarybe sure you or whatever credential you are running as has rights to the location of that foxpro file .dbfYou can click on Advanced if you need to specify other special settingsThen click NextHere select the database to where you want to import the FoxPro dataClick nextThen you can specify if either you want to write a query or just copy the database specified as a wholeif you want query you can either write it yourself or even specify a sql file. I say copy the whole database. Writing query to import foxpro tables is tricky .. select 'field1', 'field2' From 'xxx'have funcall me if you have any problems |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-01-22 : 23:40:46
|
quote:
Originally posted by yosiasz
Right click on the database you want to import TO.A window coes that says SQL Server Import and Export WizardClick NextFor Data Source select nie that says FoxProSpecify File location and user name and password if necessarybe sure you or whatever credential you are running as has rights to the location of that foxpro file .dbfYou can click on Advanced if you need to specify other special settingsThen click NextHere select the database to where you want to import the FoxPro dataClick nextThen you can specify if either you want to write a query or just copy the database specified as a wholeif you want query you can either write it yourself or even specify a sql file. I say copy the whole database. Writing query to import foxpro tables is tricky .. select 'field1', 'field2' From 'xxx'have funcall me if you have any problems
Do U Think That there is a option of uploading file on SQL 2005 Server through SQL 2005 DTS-Import\Export Wizard...because i cant find any option for foxpro there? |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-01-22 : 23:45:22
|
quote:
Originally posted by Peso
You connect FROM your SQL Server database TO the FoxPro file.
E 12°55'05.63"N 56°04'39.26"
Yes I want to connect thr foxpro file through the SQl Server and upload it to SQL 2005 |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-01-23 : 10:18:56
|
| you are missing the foxpro driver then ....it should be there. if you don't see it it ain't installed chico. |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-01-23 : 23:54:35
|
quote:
Originally posted by yosiasz
you are missing the foxpro driver then ....it should be there. if you don't see it it ain't installed chico.
Ohk Temme from where i get that foxpro driver? |
|
|
|
|
Export from FOXPRO