Search results for query: *

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

I have parsed some large text files in the past (but not that big) using VB. You open the file and parse it line by line copying each line out to a new file once it passes any test you set up. You open up a new out file every so many records. It is fairly easy to do but will take some time...

I am using Debian. Once I log into the desktop from the console I can then VNC to it from a remote host. Is it possible to set it so I can log in remotely without having to log into the console first? Thanks Simi

Fixed length is normally all the same length. You could serperate the file in to 3 files to accomodate the different lengths. Simi

If all the data is the same you should always go vertical. You can always query the data and seperate it in to fields if neccessary. But is sounds like it is all the same? Simi

Pretty good article on a Calendar table. http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html Simi