Adding new field to table and populating it

[Positive Parrot]

I'm very new to Access VB but I have managed to import a CSV file into a table with a DoCmd.TransferText command.

The next thing I'd like to do is create a new integer field in the table (e.g. month) and populate every record with the same value in the new field (e.g. 200503).

I've had a look at commands based on .Fields.Append but haven't got anything to work yet.

Any help would be much appreciated.

Regards,

PP

 

[Norie]

Can we see what code you have already?

 

[Positive Parrot]

Norrie,

Thanks for your reply. Here's the code. I've got the extra field now - I'm working on how to populate it now.

Sub LoadData()

DoCmd.TransferText acImportDelim, "Import_Spec", "Temp", "P:\Tgb01\Costs by User Feb-05.csv", True

strSQL = "ALTER TABLE Temp ADD COLUMN Month Integer"
DoCmd.RunSQL strSQL

End Sub

Regards,

PP

 

[Norie]

Try using an update query in the same way you used the ALTER TABLE.

 

[Positive Parrot]

Norie,

Thanks - I got there with SQL commands UPDATE and SET.

I can see now that Access developers use a mix of SQL and VBA.

Regards,

PP