Hi, I'm using a vba procedure to load data from a text file into an access 2007 database. One of the fields in the text file is a representation of a date as 20070829 (29th august 2007). I need to know how, within my VBA code, I can convert this to a date type in order to insert into an access field...

I'm tryin to insert some records from table1 to table2 using ssis. table1 has column1 which may contain some empty strings or padded with spaces, how do I transform those empty strings to nulls when I'm inserting into table 2. tahnks thanks sopheak

I am working with AD in C#. I wrote a simple little app that allows people to search users in AD. I have the objectSid (SID) coming back as a poperty, and I need to store that data in a database. Later in the app, I will want to search AD using that SID stored. My problem is converting objectSid ( guessing...

I had a very interesting experience today. I went to a client's office to install their new database and get it all set up with their MySQL back-end. Well, I was having many problems, and finally realized it's because I wasn't using an ADO reference in my VBA. Well, the reason it was working...

I know that the conversion isn't extremely hard but I want to know if there is a .NET Framework 2.0 call available for converting a URL ("file:///C:/temp/SomeFile.txt") to it's UNC equivalent no points for parsing algorithms TIA Corey2

Hi. I'm new to this but can anyone help me with how to convert seconds to hours:minutes:seconds in a sql query. My query is like this: "select duration from tablename" The column duration returns seconds and I want to format it in to hh:mm:ss in the statement. Thanks. Toti

Hi Experts here is some code segment in VB. How to convert this into VB.Net '==================================== Dim Info As FIXED_INFO Dim buff() As Byte Dim cbRequired As Integer CopyMemory(Info, VarPtr(buff(0)), Len(Info)) '==================================== ;-) Shiju

is there any way to convert a datetime to a numeric value in an SQL-statement (using MS SQL 6.5) e.g. When I use the statement select convert (float,getdate()) it returns the following message: Msg 529, Level 16, State 1 Explicit conversion from datatype 'datetime' to 'float' is currently...

How can I import a WAB address book into Outlook. Is ther e a special conversion add-on to convert a WAB into a PAB. If so where can I get such a converter?

I have a number that I am reading from a file. It is saved with comma formatting, i.e., 2,000,000.00 etc. When I try to use Double.Parse(valToConvert) it gives me an exception. Is there a way without writing code to extract out the pure number to convert this? Thanks Note to Experts Exchange - the selecting...