Importing text files into SQL using VB

[Gerald]

Hi Everyone

I am trying to import a comma delimited txt file into a SQL Server 7.0 table
- I am using VB6 as the front end and ADO as the connection type. The text
file name varies each day but basically all it has to do is be dumped into
the SQL table.

I've tried using BCP and "importdata" but I can't get hold of any sample
code that clearly shows what to do. I would greatly appreciate any help
from anyone.

Thank you

Gerald

[Omar]

Your best bet is by using DTS. There is a wizard in SQL 7.0 that
will help you build the process.

"Gerald" <geraldd@spearion.com.au> wrote:
>
>Hi Everyone
>
>I am trying to import a comma delimited txt file into a SQL Server 7.0 table
>- I am using VB6 as the front end and ADO as the connection type. The text
>file name varies each day but basically all it has to do is be dumped into
>the SQL table.
>
>I've tried using BCP and "importdata" but I can't get hold of any sample
>code that clearly shows what to do. I would greatly appreciate any help
>from anyone.
>
>Thank you
>
>Gerald