Recent content by ADoozer

Combo. Adding the debug line "Debug.Print xlWB.Sheets(1).Cells(1, 1)" prints to the immediate window without issue but the code still fails when copying the worksheet. It really looks like 2010 is not capable of copying a csv sheet to a workbook!! SkipVought I will have a play around with...

SkipVought, combo. The CSV files are generally exported files from PLC's and as such I haven't really had issues with formatting. (Duly noted your concerns with potential data changing). This sub works in older versions of excel (2003, 2007) but for some reason does not work in 2010 with CSV...

Hi All. I have a "simple" little question... I use the following few lines of code all the time for importing a worksheet from an external excel workbook (xls, xlsm, csv) into my current excel workbook. Public Sub LoadData() Dim xlWB As Excel.Workbook Dim xlMain As Excel.Worksheet...

Thanks for the input guys. John, Will replacing * with all the fields be quicker (I need to return all the fields) My laptop (the quick version) is running SQL server express (2008 R2) and the c# app is connecing by machine name The other box is running SQL full and is also being connected...

Hi All. I am having an issue with a T-SQL statement from a C# application on 1 machine. The more times the query executes the longer the time it takes to return. On my test machine the query takes less than 2 seconds (and can finish the batch in about 6 hours), but on the box in question the...

thanks for the input guys. I will have a look into the ssms object and see if that helps, but as I suspected it looks like i will need to pick apart the various system objects for the info. I will be back looking at this code at some point this week so will post some more feedback then...

Hi all... Please see thread183-1652081 I am trying to create a table with constraints to mimic an existing table. Any help would be greatly appreciated If somethings hard to do, its not worth doing - Homer Simpson Jack of all trades, king of none!

Just as an update this is what i have so far (and I hope there is a much easier/simpler way of doing it) To get the column information I am using: string mySQLGetColumnData = "SELECT syscolumns.name, systypes.name, syscolumns.[length], syscolumns.isnullable, syscolumns.colstat"...

Hi folks. I have recently taken over a project which has a lot of SQL related elements. (SQL is really not my field but I can muddle through it). Anyway, the question. When I go into SQL Server Management Studio and right click on my table and select "Create To", A nicely formatted SQL...

its a bit of a hack, but you could try. Dim WithEvents objQuote As Excel.Application Dim objWorkBook As Excel.Workbook Dim objWorkSheet As Excel.Worksheet Private Sub OpenFile() Set objQuote = New Excel.Application Set objWorkBook = objQuote.Workbooks.Open("C:\File1.xls", , True)...

there are 6 data types in all hence the 3 bits. As for keeping a second file with type information, (considering an average dataset holds circa 600 million records) i think it will be easier to write and read from 1 file only (with respect to file operations im not sure of the overheads...

cpjust: let us assume i have a type 1,2,3,4 in a row:- idealy i want Hex: 20 04 33 00 50 02 00 40 00 C0 70 02 00 40 00 83 Hex: 90 02 00 40 00 82 0C this way i can read in the first byte and check bits 5/6/7 to find the type (and hence move to the next "record") if the data is saved as...

having a rough day today so thought id throw out a post for help. the scenario is this, i have a program that creates datasets, with my original coding the data was outputted as padded char's as such:- type 1 data [byte][byte][byte][byte][byte][byte] [type][ set1 ][ set2 ][qual] type...

thanks. will give the links a viewing. i assumed there may be an issue of connecting via the wan from another PC on the same network, but i got a friend to try and connect with the same results If somethings hard to do, its not worth doing - Homer Simpson too much 49374'ing, im 57005... need...

i have, and it doesnt help. even with ports 20 and 21 forwarded/open the session still times out due to no response from the server (both PORT and PASV). if i stick the server in the DMZ then i can connect.. but thats not realy a solution. nor can i do any fancy administrator settings to...