I am developing an Access 2007 "project" (.ADP) as the front-end to a SQL Server 2005 Express database.
Various tasks involve reading ".txt" files and importing their content into the database tables.
A new set of files are arriving in UTF-8 format which do not seem to have the usual "Line Feed / Carriage Return" characters for line breaks.
The content just appears as a single block of text when opened in Notepad and that seems to be the way they are seen by my VBA importing procedures (but the lines do appear separated OK when the files are opened with Wordpad).
In my VBA coding I use the following lines to open up the raw tex file :
intFileNum = FreeFile()
Open strDataFileName For Input As intFileNum
I then read through the file and process the content one line at a time with the following :
lngRowCount = 0
Do While Not EOF(intFileNum)
Line Input #intFileNum, strFullInputString
lngRowCount = lngRowCount + 1
' MsgBox "strDataFileName : " & strDataFileName & vbCrLf & _
"Input Line No : " & lngRowCount & vbCrLf & _
"Input String : " & strFullInputString
Can anyone suggest how I can handle the UTF-8 encoded file so that I get my usual line breaks?
Can I open the file in a different way or are there VBA routines to convert the files first?
Any help greatly appreciated. Thanks.