>>Convert a flat file to comma delimted and import into SQL Database format.

>>It appears to me that you can't have a variable in a query.

>>Can this be done with VB 6.0?

"Jeff Thur" <computercardio@verizon.net> wrote in message
news:6954F35E-9CB8-4072-A930-596DEDE5BBCF@microsoft.com...
> I am new to SQL and Visual Basic. I have been given the following project.
> Convert a flat file to comma delimted and import into SQL Database format.
> Users need to lookup records on the table by name or zipcode.
> The name and zipcode will change constantly. The end user will not write
SQL queries each time they want to do a lookup.
> There will be only one table in this project.
> Can a data entry screen be created so that the user can input the name or
zipcode each time they want to do a lookup?
> I am new to VB and SQL. It appears to me that you can't have a variable in
a query.
> Can this be done with VB 6.0?
> Can this be done with English Query?
> Thanks in advance for any help that you can provide.
>