Working on a small program that will read a textfile and store the rows as records in a database. At the moment I split the rows (on a given delimiter) and count how many strings I get then create a table with columns of type nvarchar(xx) and store the strings in those columns.
But suppose a row looks like this:
I'd like to figure out how these could be stored (default string).
354298 could be an integer or maybe a float
1.345 could be a float
0 and 1 could be integers or booleans
false could be a string or boolean.
Any ideas how to go about this?
This post has been edited by jens: 06 April 2010 - 02:44 AM