I have a VB6 program with Access 97 backend and we are currently trying to
change our backend to SQL Server 2000. What we need is a program where the
user could import a text file and read it into SQL. I'm able to do so but it
takes about 20 minutes to import the records (200,000+). I was wondering if
there's a quicker way to do this process. Does anyone have any suggestions
or ideas where I could look to find a better solution?
4. SQL7 Syntax