如何导入CSV和.txt文件并将数据映射到列。 [英] How Can I Import CSV and .txt File and Map the Data to Column.

问题描述

大家好，

我有一个问题我想导入CSV和txt文件，并希望该用户可以映射从csv或txt文件导入的数据来自哪个数据库列和映射该数据。那将显示在另一个框中。在映射数据后，用户可以导入数据sql server。请帮帮我。简要示例如下。



例如：

Hi All,
I have a problem i want to import CSV and txt file ,and want that user can map the data that is imported from csv or txt file is from which column of database and mapped that data . That Will display in another box . And after mapping data the user can import the data sql server . Please help me about this please . Brief example is below .

Example :

George M  21 England      // This is in my txt file 

After Import this will display Like this :

Imported data              Column Name                   Mapped Field

----------------------------------------------------------------------------------------------------

George M 21 England       *  Name    Varchar (100)    *    George (Name)

*  Gender  Varchar(1)       *    M  (Gender)

*  Age     int              *    21  (Age)

*  Country varchar(100)     *    England (Country)

----------------------------------------------------------------------------------------------------

感谢您的帮助和解答

Thanks for your word and your help

推荐答案

参见使用OleDb导入文本文件（选项卡，CSV，自定义） [ ^ ]。

这篇关于如何导入CSV和.txt文件并将数据映射到列。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！