Recent content by Alika

Thank you man

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

It works with macro! Thank you very much!

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

Exporting needs to be done programmaticaly. User uses Access application as an Interface. All user can do - is to push a button. Can a DTS Package be executed from MS Access or MS Excel (I've never worked with DTS Packages before)? If so can I get some help with code. On Internet...

Tim, thanks alot ! the application works very efficient with Pass Through Query. Tahnk you. Alika

The data is primarily stored as xls file, this is the format user receives the data. xls file usually has something about a million of records. Access will run queries with such data for something about 24h. SQL Server runs the query for a couple of minutes. This is why I think I need data to...

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

No, the name sp_ActiveAccounts is unique. It's a name of Stored Procedure located on Server I'm connecting Access application to. There is no such name in Access Tables or Queries. P.S. I don't know what ADP stands for. Sorry.

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

I have about a half of a million records. So you think it would be faster if I will first import data from txt file to Access table with do Cmd.transferText and then do some Append query to SQL Server table. I'm not exactly sure what Objects do I use. I need to establish Connection: Set Cnxn =...

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

I found an easy solution, may be it'll help somebody else: Put the statement in the beginning of the Sub, or a Loop, whereever it makes more sence: DoCmd.SetWarnings False and then turn the Warnings On when it's proper, in the end of teh Sub or after a Loop, etc. DoCmd.SetWarnings True...

jfgambit, could you be any specific please? i did it with Docmd.RunSQL "Delete * from tblTable where fileName='" & lstCtl.ItemData(varElem) & "'" How can I assign the multiple selections to the Delete query? Thank you. Alika

Mary, Many thanks! It works perfectly! Thank you! I have another question. Along with deleting files from the specified in strPath folder, the corresponding data needs to be deleted from Access table. One deleted file - one row in the table. Some times user needs to delete thousand of files...