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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: DinosBarandGrill
- Order by date
-
New Tables, Stored Procedures and UNION clauses
Thank you SwampBoogie. I have tried this already but suspect that the table needs to have been created first in order for "insert into t exec p" to work???- DinosBarandGrill
- Post #3
- Forum: Microsoft SQL Server: Programming
-
New Tables, Stored Procedures and UNION clauses
Hi forum! I have a working stored procedure that concatinates records from a number of tables via UNION. I now need to create a new table (through code) using the results of this SP and have discovered that using "select * into <newtable> from <sourcerecordset>" does not work if the...- DinosBarandGrill
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
DoCmd.Transfertext in ADPs
I need to allow users to import CSV files into a SQL database via a project file without exposing them to any dialogs other than a file select (I then pass the filename to the transfertext command). However i cannot create or specify an import specification and therefore Access creates and...- DinosBarandGrill
- Thread
- Replies: 2
- Forum: Microsoft: Access Project (ADP)
