If I want to import a CSV file into an Excel wooksheet do I have to move the data into a datatable first or can I place the data directly into Excel ?
Printable View
If I want to import a CSV file into an Excel wooksheet do I have to move the data into a datatable first or can I place the data directly into Excel ?
You can do it either way, or you can program a macro to do it and then have your app fire the macro.
thanks
I was pretty sure that it could be done but I'm having trouble finding examples of moving the file directly to Excel. I want to import the CSV to a worksheet and rename the worksheet. Do you have any links for examples?
Check out this thread by one of the moderators (RobDog):
http://www.vbforums.com/showthread.php?t=358585