Export Query records to a new table

[officework13]

i have a query with 20 collumns and 100,000 plus records. These records are made up of text, integers, dates, times, and dates & times.

To get these result in the query required me to run query on query on query & so i would like to put the new formatted data into a new table to speed up the data analysis i have to do.

This is a 1 time event that i will be doing.

What is the easiest way to do this.

I have tried exporting to exell and then importing but when importing my data gets mixed up & i get numerous import errors with the date & time.

please advise as how to successfully do what i wish to do.

 

[JunglesMcBeef]

G'day,

Have you tried highlighting all the data in the table (click the box in the further most lefthand/top corner), copy it, create a new table (design it so all fields match the new data types) and paste it?