Import Data to List Table

[Juliet]

Hi

I have an excel spreadsheet with multiple columns. One of the columns has multiple values, which I want to become a list column with multiple values.
I have separated the data with ";", but when I import the list value is either "null" or all of the data including the ";". It is not separating the data. ie
Want the list to be:
Donkey
Monkey
Lion
But it is is
Donkey;Monkey;Lion

Thanks
Juliet

 

[SOS]

You can't import to multiple records like this, along with other data. You would need to import first to a temp table and then use an append query with perhaps a function to do the job.

 

[Tdgu]

Hello,

What you would need to do would be to generate a CSV file, then import it. You can perform that operation through an open source ETL tool, free to download.

Talend Open Studio is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes.

For more information: http://www.talend.com/