Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stuartUAS
Starting Member
1 Post |
 Posted - 2012-11-01 : 12:00:09
|
Good Afternoon!
I am trying to copy a list of site names from one table into another while inserting constants into the following two fields (month integer and year integer).
I see how to insert constants OR data, but not both.
I am working in Access 2010.
Any help would be greatly appreciatged.
Stuart |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-11-01 : 14:52:30
|
Access hm? But your post is in SQL Server Dev (2000)?
I am not sure about Access but if you can show the 2 statements to insert data from table and data from constants then I am able to merge the statements for you...
Too old to Rock'n'Roll too young to die. |
 |
|
|
|
|
|
Insert data with constants