Hi,<br><br>I am using Access 97 to create a simple shipping database. I have a macro with a RunSQL command with the following statement. <br><br><b>INSERT INTO [tblShipping][Part Number] VALUES ('ABC123')</b><br><br>I am receiving a syntax error when this is run. Any ideas. I am new to SQL, so any help would be appreciated. <br><br>Tom F.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL syntax error
- Thread starter tomf
- Start date
- Thread starter
- #2
Tom it looks like you are just entering one value if this is what you want then that is fine do it this way<br>INSERT INTO tblShipping.Part Number VALUES ('ABC123')<br>Maybe that would help, I just learned SQL and that was the way we were taught! <br><br>Nina
- Status
Similar threads
- Locked
- Question
- Locked
- Question
