importing a file into a querry or array

[dreamdelerium]

im trying to import a file (any file type that can be exported from a query), programatically, into either an array or querry. i need to have in in an array or query so that i can check the structure before i insert it into a table. anyone know how to do this?

 

[neileg]

So far as I am aware, you can't. Data has to exist in a table. A query or array is a recordset that is formed from data in one or more tables. So either you read the data in the external file or you import it.

 

[Dennisk]

If you have a text file you can read that using code and store the data in a dynamic array for validation then use code to write the data to an Access table.

Search Access Help for :-

DIM, REDIM and Array
OPEN
INPUT and INPUT #