VB Forum / Database Access / September 2004

I'm creating an aplication to write and read data from database.
I need to use user authentication, not build-in account name and password.
I can't hold this parameters in file. What i must do? Maybe set in SQL for
SQL authentication?

I'm writing a VB6 app to load data from Access97 to SQL2k.  I've
successfully written code to connect to both datasources but am unsure on
how to proceed from here.  What's the best way to load an Access table to
SQL?  Do I get the Access data into a rs then load it to sql?  If so, ...

i have two files that i want data from both.  the second file has lots of
fields.  i now i could use an sql statement such as "select
customer.custnum,loans.loannum, loans.amount,loans from customer,loans", and
keep listing all the fields in the loans table to get the result, but is

have a recordset which is populated by an sql query similar "select
customer.custnum,customer lname+customer.fname as
name,loans.loannum,loans.writeoffdate from customer,loans where
customer.custnum=loans.custnum".  notice the lname+fname field.  when i

Sorry this is such a stupid question.
Sorry this is such a long post.
There, now I've got my self-aggrandizement out of the way...

Can someone point me toward code samples on how to export from SQL Server
and/or Access to a delimited text file and also importing the same into the
tables?

I'm curious if there are tools to help me migrate my Access 97 application to
VB.NET.  In particular, is there a way to automatically convert the forms in
the Access application to VB.NET Windows forms?
Many of the forms are data-bound, and would need to be converted to VB.NET