SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 IMPORT / EXPORT ISSUE
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

immad
Posting Yak Master

Pakistan
220 Posts

Posted - 04/29/2013 :  02:14:08  Show Profile  Reply with Quote
HELLO

i have a FOX PRO DATA and i want to export fox pro data into sql server 2005 but i dont have import / export option please tell me what i do

immad uddin ahmed

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/29/2013 :  02:30:53  Show Profile  Reply with Quote
add foxpro database as a linked server and use t-sql query for export

see

http://support.microsoft.com/kb/199131

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

i_am_natya
Starting Member

Azerbaijan
5 Posts

Posted - 05/08/2013 :  00:52:02  Show Profile  Reply with Quote
hello please help me

bulk insert ats.dbo.myTable999
from 'c:\Temp\yyy.txt'
with
(fieldterminator='\t',
rowterminator='\n')
----------------------
error error error
-------------
text this
-------------
003400410 20130501 142 07742 1 EV1 X NADIRZAD? EL??N NURU O?LU 474 000000000 242 000000000 0 x
003408167 20130501 142 07906 1 EV1 X M?MM?DOVA M?LAK?T ?HM?D 471 000000000 242 000000000 0 x
003408677 20130501 142 07906 1 EV30 X M?MM?DOV MIRZ?A?A NADIR O?LU 474 117150016 242 000000000 0 x
003408922 20130501 731 07906 1 EV22 X MURADOV F?RID? V?KILH?SEYN 000 117150016 242 000000000 0 x
003416005 20130501 142 07200 1 EV32 M?N24 X KAZ?MOV ?FLATUN ?LIZAKIR 474

hello yun jtgjh
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000