osubuckeye2007
New Member
- Joined
- Mar 19, 2013
- Messages
- 9
Long time reader, first time poster here.
I'm working with a lot of files where the process could be sped up by simply importing the information, rather than typing it in by hand.
Most of my source files consist of tables. Ex, an .xls with 15k rows/8 columns, a few .xsld around 20 rows/20 columns, and even some .xlsx files where entire sheets are needed. (I only need data from one type of source per file, I am not asking for a way to link to all types at once)
As I start to dabble in importing these, I'm not sure that I'm using the best method. I have searched up and down the web and cannot find a clear explanation of the differences and best uses for "creating a connection from other sources" vs "pasting as link" or even just opening the source file and copying the desired sheet into my active workbook.
Can anyone give me a quick run-down on best uses for these 3 different methods? pros and cons? or a source where I can read about the topic for myself?
I'm working with a lot of files where the process could be sped up by simply importing the information, rather than typing it in by hand.
Most of my source files consist of tables. Ex, an .xls with 15k rows/8 columns, a few .xsld around 20 rows/20 columns, and even some .xlsx files where entire sheets are needed. (I only need data from one type of source per file, I am not asking for a way to link to all types at once)
As I start to dabble in importing these, I'm not sure that I'm using the best method. I have searched up and down the web and cannot find a clear explanation of the differences and best uses for "creating a connection from other sources" vs "pasting as link" or even just opening the source file and copying the desired sheet into my active workbook.
Can anyone give me a quick run-down on best uses for these 3 different methods? pros and cons? or a source where I can read about the topic for myself?