Make New Table Query
SELECT * INTO TargetTable FROM SourceTable is the syntax used by MS jet. This does not seem to work with HXTT Access. I have used this syntax with the ColdFusion 8 drivers and it worked well. Any suggestions?
Re:SELECT * INTO TargetTable FROM SourceTable
HXTT Support
2010-05-09 22:12:40
Standard sql:
insert into TargetTable select * from SourceTable
Main
webmaster@hxtt.com