Search results

Access Front-end proceedes SQL Server back-end data. Pass-through query brings up more then 350,000 records that needs to be exported to Excel. To output the result i do: DoCmd.OutputTo acOutputQuery, "sp_PassThroughResult", "MicrosoftExcelBiff5(*.xls)", strDirectory, False, "", 0 An MS Access...

"ODBC Connection failed" in DoCMd.TransferDatabase "ODBC Database" The following statement: DoCmd.TransferDatabase acExport, "ODBC Database", _ "ODBC;SERVER=ServerName;UID=UserID;PWD=password;" _ & "DATABASE=NewAccounts", acTable, "tblNewAccounts", "tblNewAccounts" executes fine exept...

I'm exporting tables from Access database to SQL Server database (that what i really need is to export xls file data to SQL Server; I don't know if VBA lets us to do it directli, therefore, at-first I export xls file to Access db and then form Access to Server): DoCmd.TransferDatabase acExport...

In a project I'm working on I need to import a result of SQL Server View (Select-Union All sql-statement) or SQL Server Stored Procedure (the same sql-statement; I'm not sure if I get any benefits having select statement implementing as Stored Procedure, rather then simple View; perhaps there is...

Hi all. How can we import txt (dbf or xls) file to SQL Server from Access application using VBA code? Thank you

Hi. In an Access database, in a Form user selects a file name to delete it from some directory. user needs to be able to do multiple deletion at a time. I've changed the List Box property to Extended Multi Select, but I'm confused how to recode a Sub, so it will KILL all the selected files. My...

I'm sorry, i think I've posted my question to a wrong thread. I have to repost it again to the autor of this zipped Access Application: Is it possible to store the content of a selected folder (your Open Common Dialog Box example) in some temp table in Access database? Thank you. Alika