2 quick questions 1

[ossse]

I have two quick questions, where I'm trying to use Modules in MS Access

1- Is it possible to create a table that is the same as a query (copy the query as a table)?

2- Is it possible to use a Module to change the data type of a table? (change a Text to a Memo)

If you could also point me in the right direction for how to do either of these, it would be great.

Help with either or both would be much appreciated, THANKS

 

[Remou]

A Make Table Query will create a table from a query. You can use Alter Table to change the field type. It will truncate the fields without warning and all data will be permanently lost:

[tt]ALTER TABLE tblTable ALTER COLUMN ThisMemo TEXT (255)[/tt]

 

[ossse]

Thank you...

can you do the 'Make Table Query' using a Module? If so, what command do you use?

 

[Remou]

Something like:

strSQL="SELECT * INTO NewTable FROM tblTable"
db.Execute strSQL