Transfer contents of Sequential File to MS SQL Database
I am importing a sequential data file with about 5000 lines of data (generated by an application coded in COBOL) to a MS SQL Database table... Everything runs smoothly until the program hits a line that contains a period (as in: 2.5 grams). After that it starts a new line and throws eveything out of synch. Naturally everything crashes as the program tries to insert things into places where they don't belong... Right now I work around it by changing all of the periods (.) to commas (.) using a text editor before I start the import process - but it's a ponderous work around... Any ideas on how I can do this from inside VB or tell VB to accept the periods as part of the string
It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.