Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

SQL Server 2000 append table from text file

i will be receiving a fixed width or a comma separated file from my vendors.  they will match the columns in my table.  I am using Visual Basic (2008) to match the vendors freight bills against the shipping table.  so I want to append the file i will receive everyday to the freight bill table when my user selects the vendor and clicks a button.  so how do I make this happen?  Would it be best to write a stored procedure and call that in my code or figure out how to write the code needed to append the daily vendor files to my db table?
0
Pioneermfg
Asked:
Pioneermfg
1 Solution
 
hesCommented:
If you are using VB then if the file is a CSV (Comma Seperated) file then just read in the file line by line then do a split on the file and that will create an array of each value that was seperated by a comma Array = Split(fileline,",")
Then insert that into a new record in the table.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now