RE: [AccessDevelopers] Re: Importing Log files

2006-01-20 Thread Trent Johnsey
FIELDTERMINATOR = ' ',     ROWTERMINATOR = '\n' )   From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of Carl Beck Sent: Thursday, January 19, 2006 6:09 PM To: AccessDevelopers@yahoogroups.com Subject: RE: [AccessDevelopers] Re: Importing Log fil

RE: [AccessDevelopers] Re: Importing Log files

2006-01-19 Thread Carl Beck
cessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of Duane Hennessy Sent: Thursday, January 19, 2006 5:08 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Re: Importing Log files   If you just want to import the log file, why don't you read t

RE: [AccessDevelopers] Re: Importing Log files

2006-01-19 Thread Carl Beck
[mailto:AccessDevelopers@yahoogroups.com] On Behalf Of Duane Hennessy Sent: Thursday, January 19, 2006 5:08 PM To: AccessDevelopers@yahoogroups.com 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 Publi

[AccessDevelopers] Re: Importing Log files

2006-01-19 Thread Duane Hennessy
If you just want to import the log file, why don't you read the file in via codePublic Sub file_open_routine()    'Author:    Duane Hennessy    'Company:   Bandicoot Software, Australia.    'Date:  6/01/2006, 12:47 PM    'Description:   description_here    'Notes: not

RE: [AccessDevelopers] Re: Importing Log files

2006-01-19 Thread Carl Beck
log   From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of Trent Johnsey Sent: Thursday, January 19, 2006 10:40 AM To: AccessDevelopers@yahoogroups.com Subject: RE: [AccessDevelopers] Re: Importing Log files   what is the file

RE: [AccessDevelopers] Re: Importing Log files

2006-01-19 Thread Trent Johnsey
lopers@yahoogroups.com] On Behalf Of Duane Hennessy Sent: Thursday, January 19, 2006 3:14 AM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Re: Importing Log files  Maybe the question was a bit too vague. :-) Elaborate a bit: 1. Which log files? Windows PC log files? SQL Server Log fi

RE: [AccessDevelopers] Re: Importing Log files

2006-01-19 Thread Carl Beck
@yahoogroups.com Subject: [AccessDevelopers] Re: Importing Log files   Maybe the question was a bit too vague. :-) Elaborate a bit: 1. Which log files? Windows PC log files? SQL Server Log files? 2. Importing into what? Access tables or SQL server tables. 3. What sort of format are we talking about

[AccessDevelopers] Re: Importing Log files

2006-01-19 Thread Duane Hennessy
Maybe the question was a bit too vague. :-) Elaborate a bit: 1. Which log files? Windows PC log files? SQL Server Log files? 2. Importing into what? Access tables or SQL server tables. 3. What sort of format are we talking about? CSV, Pipe delimited? Single lines one after another? Are you askin