Add a column to a table and populate it all the way down to the last row of exiting data

[mp3909]

Hi,

I use the docmd.transfertext to bring in data from a csv file into an access table.

The access table is called "xyz".



I now need to add a column right at the end of table "xyz" and fill in that column with the value "Dog" all the way down to the last used row of data.

How can I do this in access vba.

Thanks

[June7]

Sorry, misread question. Disregard.

[JoeM]

If you are importing into an existing Access table (and not creating a new table by virute of the import), all you need to do is to add this field to the table BEFORE you import it, and set the Default value as "Dog". Then any new record added to the table will have "Dog" populated in this field.

Otherwise, you could simply run an Update Query to populate this field after import. You can do this in VBA very easily. Just set up the Append Query, and create a Macro that opens that Query. Then, select that query and select "Convert Macros to Visual Basic", and that will convert that command to VBA code for you.

[mp3909]

this is in access my friend, not excel vba

[mp3909]

Bing: excel vba autofill down to last row

https://www.mrexcel.com/forum/excel-...-row-data.html

this is in access, not excel vba

[JoeM]

Did you see my response?