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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ubub
-
Running a Make Table Query from VB6
This will make a new table from another tablestructure strSql = "SELECT * INTO " & strDivName & " FROM " & "Template" 'Create a table from the template db.Execute strSql 'If this is not what you are looking for then then is a DAO method in the FAQ- ubub
- Post #2
- Forum: Visual Basic (Classic)
-
Code to use "SELECT * INTO" with ADO
I have always used DAO for this task but I need to use ADO here. I wat to select files from one table and insert them into an empty table. I understand the DAO Execute method syntax doesn't work but dont know he ADO method.- ubub
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
SQL syntax for retrieving datetime record
Hi, Using Jet4 and a table I use for one of my programs I tried this syntax to retrieve records it was successful with no errors. This uses an old style DAO database Set rs = db.OpenRecordset("Select * From [MatchTable] Where [DatePlayed] = #10/8/2000 12:01:40 AM#", dbOpenDynaset)...- ubub
- Post #4
- Forum: Visual Basic (Classic)
