Terence-
You'll probably have to use a passthrough query to a procedure to make the table on the server. I don't think SELECT INTO will honor an IN clause to direct the output to the server, but you could try it.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Feb 1, 2014, at 10:00 PM, <buffalome000@yahoo.com> <buffalome000@yahoo.com> wrote:
I am not looking foward to this conversion,
Make tables, is there a way to have make tables created in the BE, (i.e. the SQL Server) ?
Terence
I have a table in the BE on the SQL Server, I created a querry which would create a maketable thinking it would utilize the existing table in the BE, but it didnt.
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar