Upload data from textfile into Ms Access which using delimiter

Question

0.00/5 (No votes)

See more:

Hye all,

I need to upload data from textfile(*.txt) which using delimiter as separation for a data:-
Example:

07010000584|MY COMPANY SDN|752|PRESLEY ROAD|TEXTILES|BLUE|3873.50

What is the code to upload this file into database which using delimiter? Should it need to upload to dataset first?

I hope someone out there can help me..assume that each value in delimiter is just like a data in column.

Posted 2-Jan-12 20:36pm

Luiey Ichigo

Updated 2-Jan-12 20:52pm

Mehdi Gholam

v2

Add a Solution

2 solutions

Solution 1

Do you have to do it programmatically? If you don't, I would recomend opening it with Excel and saving it as an Excel file, then import that file into Access. If you do, select the cells, then under the Data tab, select Text to Columns and follow the wizard to convert it to cells.

Posted 3-Jan-12 10:29am

Kevin Schaefer

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2012-01-03T11:42:00

One way is to use for example use File.ReadAllLines[^]. This would get you an array of string. For each string in array use Split method to break it into columns. After that use those string arrays as parameters for your insert statement. So something like:

C#

string[] fileLines = System.IO.File.ReadAllLines("somefilename.txt");
foreach (string line in fileLines) {
   string[] cols = line.Split('|');
   // insert to database goes here...

}

Upload data from textfile into Ms Access which using delimiter

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Upload data from textfile into Ms Access which using delimiter

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us