Search results for query: *

Hi My apologies for not replying.I was on holidays. Yes there are nulls for the first couple of rows in these columns, but the column is formatted as time. thanks,

The regional settings are the same. The column is being read in as null so I cant convert it. I converted the column to a Time format and that didnt make any difference. thanks,

I have an Excel Comma seperated values file (A) and a macros file (B). On my machine B reads A perfectly but on another machine B does not read 2 columns which are formatted custom H:mm:ss. Does anyone know why this would happen, or what I can do to fix it.This is a copy of the code I am...

Yes Sorry I should have done that at the start!. I have a workbook with macros in it. This is the code Set m_conXLS = CreateObject("ADODB.Connection") Set m_rsXLS = CreateObject("ADODB.RecordSet") Set rs = CreateObject("ADODB.RecordSet") Set rs1 = CreateObject("ADODB.RecordSet")...

Hi I have an Excel Comma seperated values file (A) and a macros file (B). On my machine B reads A perfectly but on another machine B does not read 2 columns which are formatted custom H:mm:ss. Does anyone know why this would happen, or what I can do to fix it.

Its SQL Server. I actually got it sorted though. thanks. My code had been reading the XMLDocument 4000 times and just taking the current index. I now use SelectNodes and iterate through that and it takes no time at all. thanks for the reply anyway

Hi Apologies if I am not in the right forum but I have a vb6 application which inserts an xml file into the database record by record. I make up the insert sql stmt and do an execute. however it takes 4 minutes to insert 4612 records. I had originally gone it using .NET and it takes 37 seconds...

hi thanks for replying. So I have a form with a From Date and a To date which are DTPicker controls and a command button. I have code behind the button. the button sets the variables below. The variables are declared in the declarations section of the form as so Public MMLate As Long Public...

Hi I have recently moved from Windows 2000 and Access2000 to Windows XP and Access2003. One of my reports references public variables on a form. It works fine on Win2K/Access2000 but not on XP/2003. Some of the machines it works on have access2002 on them so I am wondering is it a file or...

Sorry I should have said I am importing the spreadsheet into a SQL server table.

Hi, i want to import an excel spreadsheet using Visual Basic. I have done it in VBA using the docmd.transferspreadsheet but I cant seem to find an easy way of doing it using vb. anyone any ideas. thanks,

Hi, Does anyone know if you can pass in a filename for a DTS package. I did the import and saved the package but I want to run the same procedure on different filenames. When I did the import I had to select the filename.At the moment I have three different packages even though the structure of...

Yes muy references are all fine.

Hi I have an Access2002 database with forms, reports etc. I have a report that displays some public variables from one of my forms. It all works fine in Access2000 (database was created using this) but when I run it on Access2003 all that comes up is ?name# as if it can't find the public...

I tried that and it made no difference. I get no new window or no error message. I can see the Excel file on the server so know its creating that. thanks,

Hi, I have an asp page which opens an Excel object, fills out a spreadsheet, renames it and opens it in a new window. Works fine on all the machines except for one. It creates the excel spreadsheet but the window does not seem to open. I have compared the Internet settings and they are the...

I tried the code and it seems to work fine. I need to get them in to the same order though but its certainly a step forward. Its an invoice file so the identifying field is the invoice number. I can see that there are 2 new invoices for this month but there might be new items for some previous...

Hi, I get an excel file everymonth which is cumulative so it contains the previous months details plus this months. Is there any way I can compare the two files so that I can then delete the ones I have previously dealt with. It has to be a cumulative file because its a 3rd party product. Its...

Thanks for your help. I have followed the Microsoft suggestions and even ran a Removal tool from Symantec which says the virus is not there, yet it keeps coming up when I access the database using Enterprise Manager on my local machine. I installed the SP3 on my machine as well but am not...

Hi, We are using SQL Server 2000 and I have Enterprise Manager on my local machine. When EM is open the firewall says that the Slammer Worm is active. When I close it down it goes away. I have read all the Microsoft info on it and their best solution was to install the SP3 which we have done...