Recent content by airwolf09

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

Andrzejek, Thank You for your help. You are right. It works perfect!

Andrzejek, Thank You for your input strCSV = Left(strCSV, Len(strCSV) - 1) Removes all commas, defeating the purpose. I only need the last comma to be removed. With CurrentDb.OpenRecordset("tbl_TEMP_ARCHIVE_ASSETS") 'Dim x As Integer For x = 0 To .Fields.Count - 1 If x <...

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...

Thanks

Yes, I understand the Excel part but I am not using Excel. I am using Access 2010. I am not trying to open the csv. I am trying to make run the process in the background. I think I figured it out. Here it is what I was able to achieve. Sub Test() 'On Error Resume Next Dim objFSO, dataArray...

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...

Thank You for your reply. I see the relationship. Always a pleasure to have experts like you around.

Records would be guaranteed. There could be any amount of assets but if a column for grouping is required, the same amount of fields would be available. GrpNum Field1 Field2 3 ITEM 1 3 ASSET 12345 3 MODEL 1234ABC 2 ITEM 2 2...

Yeah. I had a hard time trying to figure this one. How about using Visual Basic? Is there any hope there?

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...

Thank You. I didn't even realized the variables were not declared. I was scratching my head and it was a simple fix. Have a great day!!!

1 Joe Doe 1 Main St Downtown Building 2nd Floor Room 13 2 Bruce Wayne 9 Batcave Rd Bat Cave Building 1st Floor Room 1 3 Bruce Lee 1 Karate Way Chinatown Building 3rd Floor Room 5 4 Jet Li 26_Karate_Way Chinatown_Building 4th Floor Room 6 The results would be 1 Joe Doe...

I have no idea why is breaking up the data on the numeric and special characters. May be the way I am opening the file??? but I am not sure. Thanks for the help.

Sub FBI_RA_BOOKING() Dim hostSettleTimeout As Integer Dim hostSettleTime As Integer Dim osCurrentScreen As Screen Dim osCurrentTerminal As Terminal Dim returnValue As Integer Dim hiddenTextEntry As String hostSettleTimeout = 5000 hostSettleTime = 300 Set osCurrentTerminal =...