Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Works perfectly thx
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;
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"
What he said will fill Column3 and Column4 with the value 'Hyper' in every row.
Works perfectly thx