Docmd.TransferSpreadsheet
in [Queries]
|
Prev: Searching
Next: make table query SQL
From: Mikey C on 15 Aug 2006 03:37 Hello! Can anybody give me some code for the Docmd.TransferSpreadsheet command, which i can adapt for my database (or know where to get it)? I need to be able to create a command button which will export a number of tables into the same workbook at the same time. Ideally, I would like to be able to export back this way but I don't think my user-level security will let me? (Access wont let me import from Excel - even with an admisistrators password). Really appreciate the help
From: Nick 'The database Guy' on 15 Aug 2006 05:19 Hi Mikey, Docmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, varQuery(intLoopVar), strPath & "FileName.xls", 0, varName(intLoopVar) The first argument (acSpreadsheetTypeExcel9) will need to be adjusted according to what version of acccess you are using. Good luck Nick McMillen Mikey C wrote: > Hello! > > Can anybody give me some code for the Docmd.TransferSpreadsheet > command, which i can adapt for my database (or know where to get it)? > > I need to be able to create a command button which will export a number > > of tables into the same workbook at the same time. Ideally, I would > like > to be able to export back this way but I don't think my user-level > security will let me? (Access wont let me import from Excel - even with > an admisistrators password). > > Really appreciate the help
From: Nick 'The database Guy' on 15 Aug 2006 05:19 Hi Mikey, Docmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, varQuery(intLoopVar), strPath & "FileName.xls", 0, varName(intLoopVar) The first argument (acSpreadsheetTypeExcel9) will need to be adjusted according to what version of acccess you are using. Good luck Nick McMillen Mikey C wrote: > Hello! > > Can anybody give me some code for the Docmd.TransferSpreadsheet > command, which i can adapt for my database (or know where to get it)? > > I need to be able to create a command button which will export a number > > of tables into the same workbook at the same time. Ideally, I would > like > to be able to export back this way but I don't think my user-level > security will let me? (Access wont let me import from Excel - even with > an admisistrators password). > > Really appreciate the help
From: Mikey C on 15 Aug 2006 06:26 You are a true saint - thank you very much! Nick 'The database Guy' wrote: > Hi Mikey, > > Docmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, > varQuery(intLoopVar), strPath & "FileName.xls", 0, varName(intLoopVar) > > The first argument (acSpreadsheetTypeExcel9) will need to be adjusted > according to what version of acccess you are using. > > Good luck > > Nick McMillen > > > Mikey C wrote: > > Hello! > > > > Can anybody give me some code for the Docmd.TransferSpreadsheet > > command, which i can adapt for my database (or know where to get it)? > > > > I need to be able to create a command button which will export a number > > > > of tables into the same workbook at the same time. Ideally, I would > > like > > to be able to export back this way but I don't think my user-level > > security will let me? (Access wont let me import from Excel - even with > > an admisistrators password). > > > > Really appreciate the help
From: Mikey C on 15 Aug 2006 06:26
You are a true saint - thank you very much! Nick 'The database Guy' wrote: > Hi Mikey, > > Docmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, > varQuery(intLoopVar), strPath & "FileName.xls", 0, varName(intLoopVar) > > The first argument (acSpreadsheetTypeExcel9) will need to be adjusted > according to what version of acccess you are using. > > Good luck > > Nick McMillen > > > Mikey C wrote: > > Hello! > > > > Can anybody give me some code for the Docmd.TransferSpreadsheet > > command, which i can adapt for my database (or know where to get it)? > > > > I need to be able to create a command button which will export a number > > > > of tables into the same workbook at the same time. Ideally, I would > > like > > to be able to export back this way but I don't think my user-level > > security will let me? (Access wont let me import from Excel - even with > > an admisistrators password). > > > > Really appreciate the help |