By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Inserting values

P: n/a
Hi

Using code, how can I insert values such as "John Smith", 333 Park Avenue"
etc. in a table clients?

Thanks

Regards
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
If these are the only values the table requires, this will work.

Dim sSQL As String
sSQL = "INSERT INTO clients ([ClientName], [Address]) "
sSQL = sSQL & "VALUES('John Smith', '333 Park Avenue')"
CurrentDb.Execute sSQL

--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"John" <Jo**@nospam.infovis.co.uk> wrote in ...
Hi

Using code, how can I insert values such as "John Smith", 333 Park Avenue"
etc. in a table clients?

Thanks

Regards

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.