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