Discussion Locked

Getting started, I need to import an ascii file into an sql db

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I know very little about databases and even less about VB .NET but I was asked to start looking into this for a future project. We can get an ascii file from our bank with payroll information to import into our BST Enterprise 8.2A. I would like to automate this process using VB .NET instead of having our accounting department manually enter the info.

Any ideas on where to start or what direction I need to look first?

3 replies

by shellbot

I presume this will be a reoccuring action (the import).

Do you have a DBA or someone who maintains your database? If so, its a simple matter of them importing the file(s) into the required table(s). Whether they do it through DTS, batch jobs or whatever preferred action.

If looking to create a VB.Net application to use to import the files, you will generally need to use ADO.Net, which will allow you the funtionality to import and manipulate the files.

I know this is not much info for you, but where does one start...if you don't know anything about programming, no use me going into that.

by johnveal

This exactly what I'm looking for. I just needed the first (half) step in getting this started. We don't have a DBA, we're a rapidly growing small engineering firm.

Thanks again

by shellbot

I really didn't give you any info :)

Maybe a point in the right direction..but thats even stretching it..

Just ask if you need any other info :)

Cheers

This discussion is closed to new replies.