IMPORT / EXPORT ISSUE - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

SSIS and Import/Export (2012)

IMPORT / EXPORT ISSUE

Author

Topic

immad
Posting Yak Master

230 Posts

Posted - 2013-04-29 : 02:14:08

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

52326 Posts

Posted - 2013-04-29 : 02:30:53

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

i_am_natya
Starting Member

5 Posts

Posted - 2013-05-08 : 00:52:02

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources