Bonjour aux nouveaux membres Pourriez-vous mettre un avatar, merci

Data Processing Problem

spadekevin
Messages : 8
Enregistré le : mar. 19 juin 2018 13:09

Data Processing Problem

Message non lu par spadekevin » lun. 25 juin 2018 05:14

HI,

A couple of days ago I was given a txt file. In this file was about 49,000+/- comma delimited records. The data came in this format. week, id, description, qty, amtI was told to take this data and spit it out to an excel sheet in this format Store nbr Data Type Week Number Week Number Week Number
1 POS Sales 100 200 300
1 POS Qty 2 2 2
First I have to format the date in a different way. I have that down thanks to this forum. After that I am spitting all of this into a table i set up in a database.....It is taking forever, because I have to run an sql statement for each line. My question is how could I simplify this process. Could I use a datatabe, hashtable, manipulate excel easier, LINQ. Any thoughts.

Any help will be apprecited.

I didn't find the right solution from the Internet.

References:
http://www.vbforums.com/showthread.php? ... ng-Problem
Cryptocurrency App Video

Thank you.

Répondre

Réseau social

     

Qui est en ligne

Utilisateurs parcourant ce forum : Aucun utilisateur enregistré et 0 invité