Automate import of data into datasheet using a csv

[jmv]

How do I automate the import of data into datasheet using a csv file

I have a version working that populates data cell by cell in the datasheet. However I want to import the entire file at once in cases where the data is quite large ( 7 rows by 1030 columns)

Can I do this in code (c#)

thanks

jmv

 

[jmv]

Thanks

However this is what I am doing now for my 7 X 1000 2d array of data

This takes over four hours to load into the datasheet

I have the same data in a CSV file and I just thought that maybe it would be quicker to import the file into powerpoint chart datasheet

I can't seem to locate the correct syntax or else the automation of this will not work because it is looking for me to answer questions regarding the file delimiter etc. in the background

 

[jmv]

Thank you. Yes that makes sense. I am currently running it with the object displaying as it updates.