Create new table

[MSAccessRookie]

Why not just build a dynamic SQL string and use an Insert query? Seems like it would be easier.

I believe that was where my post #4 would have headed. Oh well. It is always good to see that an OP is satisfied with assistance from this forum.

 

[dcb]

Originally Posted by boblarson
Why not just build a dynamic SQL string and use an Insert query? Seems like it would be easier.

I believe that was where my post #4 would have headed. Oh well. It is always good to see that an OP is satisfied with assistance from this forum.

So I can learn, please explain how.... EDIT: Dont worry I get it (Even I can make google work)

Also the difference between Char and Text if both are 255 - why can you only create 6 Char fields?

 

[boblarson]

Also the difference between Char and Text if both are 255 - why can you only create 6 Char fields?

Don't know but for Access the use of TEXT would be the right one to use (it isn't the same as SQL Server remember. It can work sometimes with the same things, but not always and this appears to be one of them.)