SQL query syntax

[Liska Station]

Howdy!
I usually prefer Visual FoxPro, so Access isn't really my thing, and I can't
seem to find a good example of a SQL query in Access's syntax.

What I'm attempting to do is take data from fields in the current record (in
Access) and insert them into a remote SQL table (a standard SQL INSERT INTO
() command)

Anyone got a good example of the syntax for this in Access?

Thanks!

-Duffy

 

[Kgwill85]

Howdy!
I usually prefer Visual FoxPro, so Access isn't really my thing, and I can't
seem to find a good example of a SQL query in Access's syntax.

What I'm attempting to do is take data from fields in the current record (in
Access) and insert them into a remote SQL table (a standard SQL INSERT INTO
() command)

Anyone got a good example of the syntax for this in Access?

Thanks!

-Duffy

Check this site out...
http://www.w3schools.com/sql/sql_insert.asp

 

[Liska Station]

(e-mail address removed) wrote in @g12g2000prg.googlegroups.com:

http://www.w3schools.com/sql/sql_insert.asp

So, I'm to take it that in Access, I can use a standard SQL query without
preamble? It will support that?

 

[Liska Station]

(e-mail address removed) wrote in @g12g2000prg.googlegroups.com:

http://www.w3schools.com/sql/sql_insert.asp

Also, this page doesn't give any useful connect strings that'll work from
Access. Sorry if I'm being dense, but this looks kinda useless for what I'm
trying to do. I'm perfectly capable of structuring a SQL query. I just need
to know the syntax for using it from Access (specifically an ONCLICK
event).

What I need is Access's equivalent of SQLSRINGCONNECT() and SQLEXEC() (I've
no idea what these functions are called in Access)

Thanks!

 

[Liska Station]

Well, if anyone's following this thread, this isn't everything I needed,
but I can sludge it out from here, I think.

This gives Access's "equivalent" of SQLSTRINGCONNECT()

http://www.washington.edu/computing/web/publishing/mysql-access-3.5.html

Basically you have to install a 3rd party ODBC driver (in my case, the
MYSQL ODBC DAO) and go through a wierd little query wizard to make access
treat a SQL table as a local data source.

Then, once you've added a query "profile" you can access it much like you
would a local table (or such is my understanding thus far.)

I'd bet money that there's GOT to be a cleaner way to do it than this, but
if you tend to use a higher caliber program on a regular basis, such as
Visual FoxPro or C++, and you aren't familiar with the ins and outs of
Access, this should get you started.

Hope this helps anyone else in a pinch!

Cheers.