Click here to Skip to main content
12,448,720 members (54,448 online)
Rate this:
 
Please Sign up or sign in to vote.
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
Kapilkp368
Updated 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160811.3 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2016
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