is there any way to specify a particular sheet in a workbook if you have more than 1 sheet when you do a transfer spreadsheet for importing in data from an Excel 97 spreadsheet into an Access DB (97) ?
I'm wondering if SQL Server has the capability to import in Excel files such as Access can import in Excel files as tables.
If so can you outline the general steps ?
Thanks !
Say two tables have exact same table structure:
Table 1
Food Price Tax
Table 2
Food Price Tax
How do you get the sum of
food (table1.price+table2.price) (table1.tax+table2.tax)
I'm very familiar with SQL writing using Oracle but I'm having a ton of problems trying to do this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.