Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server-2008
i need to store unicode data in a file format which could be later on imported in the database ?
 
i want to copy my table data(containing unicode) in a file and that file will be imported later to the database
Posted 17-Jan-13 23:12pm
Kapilkp351
Edited 18-Jan-13 1:03am
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

using the export wizard we can write the data on the flat file and can again import the file in any other database table having the same structure using import wizard
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

SELECT * INTO XLImport1 FROM EXCELLINK...[Customers$]
or
You can also execute the query against the source in a passthrough manner by using OPENQUERY as follows:
SELECT * INTO XLImport2 FROM OPENQUERY(EXCELLINK,
    'SELECT * FROM [Customers$]')
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 305
1 _Amy 235
2 Peter Leow 205
3 Andreas Gieriet 180
4 Dave Kreskowiak 130
0 OriginalGriff 7,540
1 Sergey Alexandrovich Kryukov 6,412
2 Maciej Los 3,849
3 Peter Leow 3,653
4 CHill60 2,712


Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100