Hi,I'm a relative newbie to SQL Server but I'm having to learn it to accomplish some goals for some web development I'm currently doing.I need to import a csv file (has to be csv, the originating app doesn't export as anything else:() which has a format like so:Phoenix_Rising13:18 29 Jul 2002andyu,1, 73535.27 ,6691,44TPR_Mulda,2, 37553.49 ,2152,342Alta_Rica,3, 31177.67 ,2061,433riddlermarc,4, 26567.64 ,2030,508etc...etc...
The third field is the one I want to import (eg 73535.27), the values are to be inserted into a new column in an existing table against the relevant username (andyu, TPR_Mulda etc).Also, I don't want to import the top row (Phoenix Rising) but I want to import the second row (time/date) to be the name of the new column.My goal is to populate a table on a daily basis that stores statistical data for my Genome@Home team, I need to record how many units each member produces on a daily basis.. from this I can pull the information out via ASP and have it available on a website (that's the easy part, I'm proficient in ASP/PHP etc..).I need to automate this import at 5am every morning too as my app that downloads the statistical data is set to run at 4am every day.. can anybody point me in the right direction, please?Regards,Marc
Import csv with separate date header..
Posted - 2002-07-29 : 08:53:32
