Update or Append? and how to accomplish this?

[Espinoza84]

What about UNDERSCORES in column names?

Will they cause headaches in transferring a db from access to sql too?

 

[MSAccessRookie]

What about UNDERSCORES in column names?

Will they cause headaches in transferring a db from access to sql too?

Underscores do not currently seem to be a problem for SQL Server, MySQL, and Oracle, but have been reported as problematic on other platforms, but there is no guarantee that future releases of SQL Server, MySQL, and Oracle will remain supporting that character.

 

[georgedwilkinson]

Sounds like everything is resolved? We know why nulls don't matter? We know how to open a dl database r/w? We know about legal and illegal special characters? And we got the table updated?

Life is good.

 

[sbenj69]

I opened the extracted database, and ran the query only to find that it did not work. Further inspection shows that it could not have worked because neither table had complete data, and in fact, one of them was blank.

Correct..... I did that on purpose, so he could run the append query, and then update the missing email fields in the updatetbl, and then run the update query.

The update query does, however work..... I just erased the updatetbl info so he could run the append query, fix the missing emails, and then run the update query.

Heh, guess I should have left instructions on what I did....... I wanted to show the difference between append and update.......

 

[MSAccessRookie]

Correct..... I did that on purpose, so he could run the append query, and then update the missing email fields in the updatetbl, and then run the update query.

The update query does, however work..... I just erased the updatetbl info so he could run the append query, fix the missing emails, and then run the update query.

Heh, guess I should have left instructions on what I did....... I wanted to show the difference between append and update.......

With that information in hand, I ran it again and it worked as advertised

 

[MSAccessRookie]

There seems to have been some confusion here among some of the posters that I didn't see clarified.

1. You use an update query when you want to modify column values for an EXISTING row.
2. You use an append query when you want to insert NEW rows.

Actually Pat, I made "A Rookie Mistake". I assumed that the second table was already populated and that I did not need to make that effort. Once the situation was explained, it worked out fine

 

[sbenj69]

I blame me

It's this Attention Deficit Disorder thing. Sometimes I get ahead of myself.

 

[MSAccessRookie]

I blame me

It's this Attention Deficit Disorder thing. Sometimes I get ahead of myself.

Methinks I know EXACTLY how you feel!