Another stupid question...how do I load a CSV file?

[Anonymous]

Hi guys,

I have a CSV file that needs to be loaded into my application. I couldn't find the CSV version when I clicked "Table Files" icon...

I can find it's excel version though.

Thanks,

Lynn

[Nicole-Smith · Accepted solution]

CSV files should show up after clicking on "Table Files", just leave the "Files of type" set to "All Table Files":

[MK_QSL]

Click on Table Files

Select Your CSV file

it will give you screen with Delimiter ...etc

very simple

[Anonymous]

in the window where you are supposed to see your files and select one, make sure your "files of type" is "all table files". that should help!

nicole beat me to it..what she said!

[Anonymous]

Thanks, guys, I found it in "Table Files" but the script looks like this:

"Directory;

Load @1

From

[.........]"

What is "@1"?

[MK_QSL]

Labels >> Select Embedded Labels

This will give you column name as FieldName...

If your CSV files don't have header or Column name select

Labels >> None

and give name to your field

like below

@1 as FieldName1,

@2 as FieldName2 etc

[veidlburkhard]

This is the default column header when the wizard doesn't find one. Seems you missed to mark 'Embedded Labels'.

Hope this helped.

Burkhard

[its_anandrjs]

Hi,

@ is a Explicit labels if take this labels is also working but you need to change some names for your fields like

Load

@1 as Fieldname1

@2 as Fieldname2

From

[.........]"

other wise select

Labels -> Embedded labels

Hope this helps

Thanks & Regards

[Anonymous]

YEAH~~ Finally, I got it successfully loaded!! Thank you guys!