External Connection to Table (not Pivot table)

[mark hansen]

I just what to make sure I'm not over looking anything. I'm trying to set up an external connection to a text file that's in CSV format, and have it go into a table. I'm capturing data from many users each time something happens, and they can each write a line of data into the text file. Each line appends to the file. Data entry users are using a workbook hosted on SharePoint so they all can use the same file at the same time. Nothing is saved in the SharePoint file, it's just a template to create the data string.

The person doing the monitoring will open another workbook and read in the text file to monitor what is going on. The data goes into a table to work with it easier.

From my research and experimentation, I'm beginning to realize you can't have an external connection directly into a table. Is this correct?

My current workaround is to have the connection to a separate sheet. Then code will copy the information from that sheet and copy it into the table.

Is this the way I need to go, or am I overlooking something.

We are using Excel 2010.

Thanks for any insight