microsoft sql server 2008 [英] microsoft sql server 2008

问题描述

我需要以文件格式存储unicode数据，以后可以在数据库中导入吗？



i想要复制我的表数据（包含unicode）一个文件和该文件稍后将导入数据库

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

推荐答案

使用导出向导我们可以在平面文件上写入数据，并可以再次导入任何文件使用导入向导具有相同结构的其他数据库表

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

SELECT * INTO XLImport1 FROM EXCELLINK ... [Customers

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

这篇关于microsoft sql server 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！