Create queries trough code

[Alban GOBIN]

I've some troubles on writing a code that creates 450 Access Queries from
a txt file that contains their SQL syntax...
I'd like that to run automaticly without the user's intervention.
Please help me to find procedures and syntaxes to do that because I'm a beginner
in that domain.

Thanks and please forgive my english speech.

[Mike Hutton]

This might serve as a good starting point...You can run it in an Access module.
(In Access97 anyway)
_____________________________________________________________

Sub AddQueries()
Dim QD As QueryDef
Dim SQL_From_Text As String
Dim I As Integer

Open "c:\mytext.txt" For Input As #1

Do While Not EOF(1)
Input #1, SQL_From_Text
Set QD = New QueryDef

QD.Name = "NewQuery " & I
QD.SQL = SQL_From_Text

CurrentDb.QueryDefs.Append QD
I = I + 1
Loop

Close #1
End Sub


"Alban GOBIN" <lgobin@brutele.be> wrote:
>
>I've some troubles on writing a code that creates 450 Access Queries from
>a txt file that contains their SQL syntax...
>I'd like that to run automaticly without the user's intervention.
>Please help me to find procedures and syntaxes to do that because I'm a
beginner
>in that domain.
>
>Thanks and please forgive my english speech.