I want to import couple of excel files in my data. Below are the details of 1 of the excel file. I would like to have a simple VB code or some macro or query to import the data<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Excel File Name: File_1<o></o>
TAB Name: TAB_4 (there are multiple tabs in the file)<o></o>
Column Heading Start: Column B<o></o>
Column Heading End: Column AI<o></o>
Field Heading: Row 4<o></o>
Data Start: Row 5<o></o>
Data end: dynamic<o></o>
<o> </o>
The problem I am facing in importing the data is the data heading starts from row 4 and row 1 through 3 are filled with un-required information for my process<o></o>
<o> </o>
Can you please help me getting a code for this type of import. I need it asap to build some reports after getting this information.<o></o>
<o> </o>
Let me know if you need more details.<o></o>
<o> </o>
Excel File Name: File_1<o></o>
TAB Name: TAB_4 (there are multiple tabs in the file)<o></o>
Column Heading Start: Column B<o></o>
Column Heading End: Column AI<o></o>
Field Heading: Row 4<o></o>
Data Start: Row 5<o></o>
Data end: dynamic<o></o>
<o> </o>
The problem I am facing in importing the data is the data heading starts from row 4 and row 1 through 3 are filled with un-required information for my process<o></o>
<o> </o>
Can you please help me getting a code for this type of import. I need it asap to build some reports after getting this information.<o></o>
<o> </o>
Let me know if you need more details.<o></o>