Search results for query: *

Thanks for the info. I actually just saw that in the help file of access where you can go name what sheet you are looking for in the range section. Thanks again for the reply !

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) ?

Thanks so much for your help.

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 !

I think that I'm having problems more with the syntax than anything else. I'm using Access 97 version and trying to code in the Access SQL window of the query tab. In the particular tables that I have there are three tables say: Input 1, Input 2, Total Table All three tables have three same...

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...