flat files

[Former Member]

hi

i need import information from a flat file, but whit loader of maxdb can't do it this work.

how i can do this ??

thanks for your help

[lbreddemann]

HI Alexander,

as the other replies already point out the solution depends on the current format of your flat file.

If the data is available in CSV format you may well use the loader tool.

If the data is in some other format you will have to process it before inserting it into the database - at least the data sets should be in row-like format.

For extended data maniulation I would recommend to use perl or python as this enables you to read your text files efficiently and at the same time access your MaxDB instance with ease.

For details on this you may want to check the MaxDB documentation for the Perl/Python Interfaces.

Best regards,

Lars

[steffen_schildberg]

Hi Alexander,

what exactly is the problem with importing flat files using the Loader? What format do your flat files have - CSV or FWV?

Do you encounter an error while importing?

Regards,

Steffen

[Former Member]

Hi Alexander,

a CSV-file or similar structured?

You could link your file and the destination table in MS-Access and just make an Append-Query.

You can also use the Access-VB functions to potentially modify the source data in an appropriate way.

Georg