It isn’t straight data to bring in.
Access also kicks the file as though the file doesn’t exist.
I just found MS log converter which still doesn’t
produce a positive result or Access readable file.
I hadn’t tried the free file.
If you just want to import the log
file, why don't you read the file in via code....
Public Sub file_open_routine()
'Author: Duane
Hennessy
'Company: Bandicoot Software, Australia.
'Date:
6/01/2006, 12:47 PM
'Description: description_here
'Notes:
notes_here
Const strcProcedureName As String =
"file_open_routine"
On Error GoTo err_
Dim file_number As Integer 'Holds FreeFile number
Dim read_string As String
Const file_path As String = "c:\myFile.log"
'Create file
file_number = FreeFile(0)
Open file_path For Binary Access Read As
file_number
While Not EOF(file_number)
Line Input #file_number, read_string
Wend
Close #file_number
exit_routine:
Exit Sub
err_:
MsgBox Err.Number & vbCrLf & Err.Description, 0 +
48, strcProcedureName
GoTo exit_routine
End Sub
![]()
--- In [email protected],
"Carl Beck"
<[EMAIL PROTECTED]> wrote:
>
> Yes, notepad will read the log file even if it is renamed to a txt file.
> Access still wont seem to recognized the standard W3C logging files. I can
> log to SQL but that isn't logging all the info I am looking for.
>
>
>
> _____
>
> From: [email protected]
> [mailto:[email protected]]
On Behalf Of Tobi Hoffman
> Sent: Thursday, January 19, 2006 8:08 AM
> To: [email protected]
> Subject: RE: [AccessDevelopers] Importing Log files
>
>
>
> I've done data import from various types of sources, spreadsheets, fixed
> field text files, comma (or other) delimited text files -- and have never
> used sql server. What I can't tell from your question is what type of file
> your log file is. Can you open it in Notepad and see how the data looks?
> Have you tried linking to the file? What extension does it have? Before we
> can give you any help, we need more information.
>
>
>
> Tobi
>
>
>
> _____
>
> From: [email protected]
> [mailto:[email protected]]
On Behalf Of Carl Beck
> Sent: Wednesday, January 18, 2006 11:28 PM
> To: [email protected]
> Subject: RE: [AccessDevelopers] Importing Log files
>
> I take it no one has log file import information with out using sql server
> to capture logging info.
>
>
>
> _____
>
> From: [email protected]
> [mailto:[email protected]]
On Behalf Of Carl Beck
> Sent: Sunday, January 15, 2006 5:31 PM
> To: [email protected]
> Subject: [AccessDevelopers] Importing Log files
>
>
>
>
>
> Does anyone have a way to import log files directly into Access?
>
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
>
>
>
>
> SPONSORED LINKS
>
>
> Microsoft
>
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+developer&w1=Microsoft
>
+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4=M
>
icrosoft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+ac
> cess+programming&c=6&s=193&.sig=d-CjBIrYOH9NCKHYFeGZJA>
access developer
>
> Microsoft
> <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+help&w1=Microsoft+acce
>
ss+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4=Micros
>
oft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+access+
> programming&c=6&s=193&.sig=crx-d4AAhdklv_VozGVAUw> access
help
>
> Microsoft
>
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+
>
access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4=Mi
> crosoft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+acc
> ess+programming&c=6&s=193&.sig=qg2hDuQNweByMCX0NU7cEA>
access database
>
>
> Microsoft
>
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+training&w1=Microsoft+
> access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4=Mi
>
crosoft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+acc
> ess+programming&c=6&s=193&.sig=bLZHqTqWUQny609X1OkmNA>
access training
>
> Microsoft
> <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+training+course&w1=Mic
>
rosoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databas
>
e&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6=Micros
>
oft+access+programming&c=6&s=193&.sig=d8GQXfQW3RZ64rOfzIMo8A>
access
> training course
>
> Microsoft
>
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+programming&w1=Microso
>
ft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4
>
=Microsoft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+
> access+programming&c=6&s=193&.sig=iXDlL79-kkgjv6fLyFu3Sg>
access
> programming
>
>
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "AccessDevelopers
> <http://groups.yahoo.com/group/AccessDevelopers> " on the web.
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
<mailto:[EMAIL PROTECTED]>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
>
> _____
>
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
YAHOO! GROUPS LINKS
