Using INSERT INTO and setting one field value - Access VBA

Question

I'm using INSERT INTO to copy rows of data from one table to another:

INSERT INTO tblNewCustomers (CustomerID, [Last Name], [First Name])
SELECT CustomerID, [Last Name], [First Name]
FROM tblOldCustomers

How can I set one of the field values in tblNewCustomers for all of the new records that I am importing in withn this statement e.g

tblNewCustomers.existCustomer = TRUE

Thanks in advance for any help

Noel

Smandoli · Accepted Answer · 2010-04-13 11:42:07Z

7

INSERT INTO tblNewCustomers (CustomerID, [Last Name], 
    [First Name], [existCustomer])
SELECT CustomerID, [Last Name], [First Name], True 
FROM tblOldCustomers

answered Apr 13, 2010 at 11:42

Smandoli

7,0593 gold badges53 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

noelmcg Over a year ago

Brilliant, thanks Smandoli. Hoped it would be simple to do, I had no idea how to structure it.

Smandoli Over a year ago

@Daniel Dolz: Yes, you are right -- setting a default value in the table is usually the straightforward solution. But using SQL opens up many possibilities -- inserting different values, most obviously. In particular for Union queries, this SQL device "disambiguates" the table source and forces distinct rows: SELECT *, "A" AS Marker FROM tbl_a UNION SELECT *, "B" AS Marker FROM tbl_b

Daniel Dolz · Accepted Answer · 2010-04-13 16:53:59Z

0

You can also ignore the field in the SQL sentence and make it have a default in true. BUT I think Smandoli solution is more accurate

answered Apr 13, 2010 at 16:53

Daniel Dolz

2,4311 gold badge18 silver badges23 bronze badges

Collectives™ on Stack Overflow

Using INSERT INTO and setting one field value - Access VBA

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related