Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jfieck
Starting Member
6 Posts |
 Posted - 2005-06-03 : 12:15:22
|
| I am working in MS Access 2000. I have a query that is returning a table with various types of data. The problem is I can't seem to find anywhere in the Access GUI that will show me the data types of columns it has returned so I can't manually create a table to hold the values returned by query. Questions is two fold:1. Is there a way in Access SQL to import data returned from a query into a table that is not yet defined. Some like this:a. Create a table that has a primary key but doesn't yet know the number of columns and/or data types of those columns.b. Import the data from a query into this table and have it create the columns and copy the data types and populate the table while also numbering each row by primary key.or2. Is there a way to find out what the data types are for a table returned by a query in MS Access. I can't find anthing!!!Any info would help. Thanks. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jfieck
Starting Member
6 Posts |
Posted - 2005-06-03 : 12:26:10
|
| Thanks. I'll move this out of here. |
 |
|
|
|
|
|
Dumping Query Date to an undefined table..?