RE: [AccessDevelopers] Re: Importing Log files

Trent Johnsey Fri, 20 Jan 2006 08:49:15 -0800

Thanks for sending the solution out. Not that I was much help, I did quick research on the file format you referenced, and saw the fields had only spaces as delimiters, which is always problematic. Good Luck!
TJ

Carl Beck <[EMAIL PROTECTED]> wrote:

Found this on MSDN solves my log import issue, I will have to import directly to SQL or script it out in Access.

Thx for all your help Duane, Trent and Tobi

Carl

use the Query analyzer to run this script

CREATE TABLE [dbo].[tablename] (

            [date] [datetime] NULL,

            [time] [datetime] NULL ,

            [c-ip] [varchar] (50) NULL ,

            [cs-method] [varchar] (50) NULL ,

            [cs-uri-stem] [varchar] (255) NULL ,

            [cs-uri-query] [varchar] (2048) NULL ,

            [sc-status] [int] NULL ,

            [sc-bytes] [int] NULL ,

            [time-taken] [int] NULL ,

            [cs(User-Agent)] [varchar] (255) NULL ,

            [cs(Cookie)] [varchar] (2048) NULL ,

            [cs(Referer)] [varchar] (2048) NULL

            )

then run

BULK INSERT [dbo].[tablename] FROM 'c:\weblog.log'

WITH (

    FIELDTERMINATOR = ' ',

    ROWTERMINATOR = '\n'

)

From: [email protected] [mailto:[email protected]] On Behalf Of Carl Beck
Sent: Thursday, January 19, 2006 6:09 PM
To: [email protected]
Subject: RE: [AccessDevelopers] Re: Importing Log files

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.

From: [email protected] [mailto:[email protected]] On Behalf Of Duane Hennessy
Sent: Thursday, January 19, 2006 5:08 PM
To: [email protected]
Subject: [AccessDevelopers] Re: Importing Log files

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

Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.

Please zip all files prior to uploading to Files section.

SPONSORED LINKS

`Microsoft access developer`	`Microsoft access help`	`Microsoft access database`
`Microsoft access training`	`Microsoft access training course`	`Microsoft access programming`

YAHOO! GROUPS LINKS

Visit your group "AccessDevelopers" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [AccessDevelopers] Re: Importing Log files

Reply via email to