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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to convert ADODB.recordset to Tabledef
- Thread starter javaRocks
- Start date
You can use ADOX or SQL to define a table in code. To get the field names Rs.Field(i).Name. Look at the other recordset properties--not sure it recordset exposes enough info to provide datatype length & degree/precision.
You will need to use ADOX to get these properties from the source table if Rst doesn't provide.
You will need to use ADOX to get these properties from the source table if Rst doesn't provide.
- Status
Similar threads
- Locked
- Question
- Locked
- Solved
- Locked
- Question
- Locked
- Question
