Make Query - Defining fields

[Torsan]

When I run this query, the fields in the new table contains 253 characters. How do I specify in the SQL command that the field Carg2 and Carg3 will contain 3 charachters ?

SELECT dbo_allesc.AccReport, Left([AccReport],2) AS Carg2, Left([AccReport],3) AS Carg3,.........................
INTO regTabell

Thank you, Tor

 

[MicroE]

After you create the table – change the field size.

Then instead of using a make table query – use a delete query followed by an append query.

 

[Torsan]

Thank you. Again MS Access proves that MS Fox Pro is way better.