Add column while loading

[#1]

Hi all,

i'm in front of a little issue that i do not manage to solve.

I have an Access table that i can't modificate that i load trough script; so far no problem.

My question is: can i write something in the script of this table that would enable me to add a column directly from the script and enable me to avoid modificate the Access table?

More in details:

I load a table, but i would like to add a columns with the same text in each cells. text would be for instance: "Hyper"

i hope i'm clear.

i don't know if that's possible but i think it is, that's why i ask [^o)]

Thanks all

[vidyut]

Hi,

Yes, It should be possible. Here is an example, where you get Column 1&2 from Access and Column 3&4 are added while loading the data:

Load Column1,Column2, 'Hyper' as Column3,'Hyper' as Column4

From YourAccessDBTable;

[#3]

Thanks,

but i think that this would just change the name of the column; altought, i'd like to fill the whole column wit "Hyper"

[johnw]

What he said will fill Column3 and Column4 with the value 'Hyper' in every row.

[#5 · Accepted solution]

Works perfectly thx