Search results

Hi, You need to split the time part out from the date part of your date time field, because the time part of the date time field is not the same for every instance of 30/06/2012 for example: 30/06/2012 00:10 30/06/2012 00:20 30/06/2012 00:30 these are not seen as being the same, because as...

Hi Paul, I've reformatted the text file again this time removing all spaces preceeding the < and re-ran the code and the table has been updated.:o I feel a complete you know what, thanks once again for your professionalism. Regards John

I placed my cursor at the end of <Song> and pressed the return key to get the following: <songList> <Song FilePath="C:\Users\John Lee\Music\00's\All Saints\On & On.wma" FileSize="5773158"> <Display Author="All Saints" Title="On & On" Genre="Pop" Color="7693971" Tag="2" /> <Infos...

Hi Paul, I've been trying to work out why the code you supplied keeps falling over when it reaches this block of code, without any success: fieldStr = "(" & Left(fieldStr, Len(fieldStr) - 2) & ") VALUES (" valStr = Left(valStr, Len(valStr) - 2) & ")"...

Hi Paul, I guess you're getting a bit fed up with me now, but I formatted the sample file as you suggested and ran the code again and I'm still getting an error message with this line of code: fieldStr = "(" & Left(fieldStr, Len(fieldStr) - 2) & ") VALUES ("valStr = Left(valStr...

Hi Paul, Thanks very much for all your assistance I assure it has been most appreciated. A bit of manual work never hurt anyone. Regards John

Hi Paul, I've attached the sample txt file that I've been using from the beginning of this thread. Regards John

Hi Paul, I checked the tblMusic table even when the I got the following message "Runtime error '5': Invalid Procedure, call or Argument. On clicking the debug button this was highlighted in yellow fieldStr = "(" & Left(fieldStr, Len(fieldStr) - 2) & ") VALUES (" So that why I...

Hi Paul, Is this code meant to be on two seperate lines: fieldStr = "(" & Left(fieldStr, Len(fieldStr) - 2) & ") VALUES (" valStr = Left(valStr, Len(valStr) - 2) & ")" or is it meant to look like this fieldStr = "(" & Left(fieldStr, Len(fieldStr) - 2) &...

Hi Paul, No need for apologies, you've been a great help. The information I'm interested in is the Author, Title, Genre and Year. The text file in which this information is stored as you have pointed out has other information in there too. So in the text file in which this information is...

Good afternoon Paul, I ran your code against my main text file in which the sampe data came from, something I identified that I didn't with the sample data I supplied was the following: Where any records contained an apostrophe within the text of the data to be extracted only had data...

Hi Paul, Thanks once again. Cheers John

Hi Paul, Sorry to be a pain, I just noticed that any records that do not have a year associated with it, is not added to my table, is that an easy fix. Regards John

Hi Paul, Your a star, that has worked now, I don't why the asterisk was there, I did copy your code as per your post. I will also start to learn more about how to use the immediate window to debug problems, thanks for your pointers and most of all your help in solving this particular problem...

Hi Paul, I Replaced the code with your updated code and got a compile syntax error message and this part (in red) was highlighted: Edit: 11:20 hours - it was expected an expression *& "')")* To get the Immediate window to work do I type: Debug.print readtext() Do I place...

Hi Paul, I've run the code with the immediate window open, but nothing populates the immediate window. I see the same message box with the same information about a syntax error. Is there somethin I need to do to get information to populate the immediate window. Regards John

Good morning Paul, I've tried your code and I get the following message "Run-time error 3134 - Syntax error in INSERT INTO statement". I've googled this error message but couldn't find anything that made sense to my particular problem. Attached are some screen shots of the error message...

Hi Paul, Thanks for the heads up, but you were correct it is a string and not numeric. I'll let you know how I get on. Regards John

Hi Plog, Thanks for your suggestion. Regards John

Good afternoon Paul, Thanks very much for that, I will let you know how I get on. I must say I wasn't expecting it all, but it is greatly appreciated. Regards. John