This tutorial demonstrates using a Microsoft Access database from a C# application[
^]
[update] Parsing the input text:
One simple solution for your pasting is:
Split the text to elements, you will get an array of string
{ "Date", "Time", "Lat", .... , "2002/01/10", "00:44:51.53", "40.4415" .... }
then go through the values and use them.
that will be good if you are sure about the order in which those will appear in the incoming text.
This can be achieved easily like this:
string[] values = Regex.Split(YourText, @"\D+");
foreach (string val in values)
{
}
double LAT = Convert.ToDouble(values[11]);
double LON = Convert.ToDouble(values[12]);
However, I strongly suggest you learn C# Regex to accommodate for any needs that rise due to the formatting of the text, future changes and generally speaking, Regex in my opintion is pretty much a must tool for a developer.
Some Regex links:
The 30 Minute Regex Tutorial[
^]
Learn Regular Expressions (RegEx) with Ease[
^]
[/update]
Good luck,
Edo