Search results for query: *

I need to add a row into an excel spreadsheet after the last row with text in it. Either through a macro or vba. Just can't seem to get there. Any ideas recieved gratefully!

I have a .bak file which is the full backup of a database. It is a sql server7 back up. I want to run it on a 2000 version but I can't find where to do it??? I've found restore database but the wizard is confusing and I can't see where you choose the bak file to restore. do i have to create the...

I am planning on storing word documents in sql server. I have been told that the text datatype the 2gb thing)does not actually store the objects but just provides a pointer to them. Does this mean I'll have to store the documents somewhere on disk and provide pointers in the actual text field...

On an Identity primary key column, when I try to insert records from tableA to tableB, I get the truncated data error. The datatypes of the destination column and the source are the same datatype - int (4) Help??

I'm new to SQL Server and would like some help. I have a table in 2000 called clients. I want to import data in from another 2000 table called clients (which is in the original DB.)However the table in database 1 which I'm importing from has differing datatypes and sizes. How can I get the data...

I'm using a macro to run this function: Function OutputToSnapshotViewerQ() Dim Qryview As Variant,QryName As String On Error GoTo OutputToSnapshotViewerq_Err Set Qryview = Screen.ActiveDatasheet QryName = Qryview.Name DoCmd.OutputTo acOutputQuery, QryName, acFormatSNP...