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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Make table from recordset 1
- Thread starter RiverGuy
- Start date
-
1
- #2
To make a new table in SQL you would need to run a Create Table SQL statement. You would need the properties of each column from the recordsource and then pass them into your SQL statement (Type and size would do). You also need to be careful with your datatypes because certain fields may be created as numeric when they may actually be doubles, singles etc.
- Thread starter
- #3
I actually decided to make a stationary table and delte the data when I'm done with it.
Oh, ok, I should have realized. You're saying insert each column in the recordset, like rst![column1]. That makes sense. In my haste, I had got frustrated and made arrays for each column and assigned the data to arrays. I think I will change it to your way.
Oh, ok, I should have realized. You're saying insert each column in the recordset, like rst![column1]. That makes sense. In my haste, I had got frustrated and made arrays for each column and assigned the data to arrays. I think I will change it to your way.
- Status
