Recent content by simian101

I would just order your query by Toy so that it will be in order when you get to Excel. Then, use the subtotal feature in Excel or a VBA program to to add a line between each one. Simi

rtb? Simi

Just because a device is IP enabled does not neccessaryly mean you can access it's file system via IP. The device should have instructions for data transfers. It might be FTP enabled or it might require software from the manufacturer to copy data to a server. Simi

Thanks Borislav, that seems to do the trick. Excellent link Markros, I will continue to study that. Thanks Simi

I simplified my example to much... There is also a record number that I need so I can get back to record for more fields. RecNo ID Date 1001 1044 2009-07-31 14:17:43.000 1002 1044 2009-07-31 14:15:44.000 1003 1044 2009-07-31 14:11:44.000 1004 1047 2009-07-31 14:33:19.000...

Thanks George. Simi

What is the best way to get the most current dates from a list for each id? ID Date 1044 2009-07-31 14:17:43.000 1044 2009-07-31 14:15:44.000 1044 2009-07-31 14:11:44.000 1047 2009-07-31 14:33:19.000 1047 2009-08-11 16:58:41.000 1047 2009-08-10 11:51:01.000 1051 2009-08-10 12:51:01.000...

Skip as usual, you da man!!! Thanks Simi

I have done a number of odbc programs. I am running Access 2003 and Sql Server 2005. I have a basic connection (below) and I am able to execute stored procedures and run updates but I am not able to return a simple recordset? Any Ideas. Simi Private Sub Command10_Click() 'New as400 test...

Plese show an example of your command. Simi

Change the column to a text field. Simi

Try WHERE udf.udjoin = client.clnum and uddate is not null Simi

Perhaps you could show us what you want to see based on the previous example... Simi

add debug.print strsql and you will probably see the problem... Right off hand I see you are missing a ")" at the end. Simi

Just out of curosity how big is that file? 500 columns along with the billion records delimited by | (a pipe) would be 5 gig with no data. Simi