Recent content by sineados

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,