B
Benjamin
Hello
The next question that I have I really don't get it.
It has been working fine but al of a sudden it just don't.
I have a txt file dhcplog.txt I import it with:
DoCmd.TransferText
acImportDelim, "", "dhcplog", "c:\DHCPWatch\dhcplog.txt"
This works but only if I have a export.ini file in the
same directory, without it, it stops working (point 1 why
do I need that) the export.ini file contains:
[dhcplog.txt]
ColNameHeader=False
CharacterSet=1252
Format=CSVDelimited
Col1=ID Char Width 50
Col2=Date Date
Col3=Time Date
Col4=Description Char Width 50
Col5="IP Address" Char Width 50
Col6="Host Name" Char Width 50
Col7="MAC Addres" Char Width 50
But the most annoying part is trying to export the table
warning:
DoCmd.TransferText
acExportDelim, "", "warning", "c:\DHCPWatch\warning.txt"
3011 The Microsoft Jet database engine could not find the
object '|'. Make
sure the object exists and that you spell its name and the
path name
correctly.
That's the error I'm getting but there is a table warning
and the txt file that's his job to make and when I pre
make a warning.txt it still doesn't work.
This line stopt working yesterday at about 02:42 pm and
from then I just don't get it working again.
Does anyone knows why? My vb sql access knowledge is not
that much so I'm stuck.
Thank you
The next question that I have I really don't get it.
It has been working fine but al of a sudden it just don't.
I have a txt file dhcplog.txt I import it with:
DoCmd.TransferText
acImportDelim, "", "dhcplog", "c:\DHCPWatch\dhcplog.txt"
This works but only if I have a export.ini file in the
same directory, without it, it stops working (point 1 why
do I need that) the export.ini file contains:
[dhcplog.txt]
ColNameHeader=False
CharacterSet=1252
Format=CSVDelimited
Col1=ID Char Width 50
Col2=Date Date
Col3=Time Date
Col4=Description Char Width 50
Col5="IP Address" Char Width 50
Col6="Host Name" Char Width 50
Col7="MAC Addres" Char Width 50
But the most annoying part is trying to export the table
warning:
DoCmd.TransferText
acExportDelim, "", "warning", "c:\DHCPWatch\warning.txt"
3011 The Microsoft Jet database engine could not find the
object '|'. Make
sure the object exists and that you spell its name and the
path name
correctly.
That's the error I'm getting but there is a table warning
and the txt file that's his job to make and when I pre
make a warning.txt it still doesn't work.
This line stopt working yesterday at about 02:42 pm and
from then I just don't get it working again.
Does anyone knows why? My vb sql access knowledge is not
that much so I'm stuck.
Thank you