Hello,
Has anyone imported the offline scan data from an NScan device into the T_NSCAN_OFFLINE_STAGE table? If so, how did you go about it? I've got the XML file off the device, and can save as a CSV or TXT file... any tips getting it in to the SQL table?
Cheers,
David Geoffrey Hall
Hi David,I've done this before. In SSMS if you right click on impresario > tasks > import then the import wizard will open and you can follow the steps there. I've always had better luck saving this as a text file otherwise Excel is likely to manipulate the data as you import it from the xml file. When I first did it I think I made a copy of t_nscan_offline_stage that I imported the data into so I could truncate said table if anything went wrong, and then I inserted the rows from the copy into the actual table.
Thanks,Will
Thanks Will, I'll give it a shot.