Search results for query: *

I use VBA to read from a txt file. Is the a way to read a txt file in 2012 MS SQL SERVER MANAGEMENT STUDIO query? Thank You

Good Afternoon The following code creates a .csv file. The output looks something like this Peter, Pan, 20, Male, Mary, Pan, 20, Female, John, Doe, 40, Male, The problem is the last comma on each row. It should no be there. Or I need to delete it. I can't figure out how to remove the last...

Hello. I am trying to figure out why the code below does not produce a new row of data. For example the old.csv shows A B C D E 1 JOE DOE MALE UNF 2 MOE DOE MALE UF 3 FOE DOE FEMALE SPACE_HERE 4 JOE DOE SPACE_HERE CAL But the output to the new.csv looks like...

Good Afternoon I need some help transposing columns to rows based on ITEM number. I am using SQL but can't seem to figure it out. My qry_Table Field1 Field2 ITEM 1 ASSET 12345 MODEL 1234ABC ITEM 2 ASSET 12346 MODEL A1B2C3 ITEM 3 ASSET 12347 MODEL 1ABC456 My desired results ITEM...

The plan 1 Access Database creates a csv file 2 Data is read by Reflections 2011 VBA code 3 Data is passed to the mainframe via Reflections 2011 VBA The problem 1 Access Database creates the csv file (NO PROBLEM) 2 Data is read by Reflections 2011 VBA code (PROBLEM) A) If leading numeric...

The plan 1 Access Database creates a csv file 2 Data is read by Reflections 2011 VBA code 3 Data is passed to the mainframe via Reflections 2011 VBA The problem 1 Access Database creates the csv file (NO PROBLEM) 2 Data is read by Reflections 2011 VBA code (PROBLEM) A) If leading numeric...

I am using Reflections 11. The VBA code works but when it comes to pass the osCurrentScreen.SendKeys "Y", It does not pass the "Y" Key. Why is that? This only happens in my If Then Else statement. Any help would be appreciated. Thank You If (Line22) = "Do you wish to continue? N" Then...

I am trying to delete the first line of text file using Attachmate Reflections 2011 VBA script. But the code does not work. How can I use "DeleteLines 1, 1"? any help would be appreciated. Const ForReading = 1, ForWriting = 2, ForAppending = 3 Dim fs, f Set fs =...