Text file with column to odbc database
I daily get logs in text file format. After I run notepad++ macro to clean
the file(junk lines and empty/blank lines)/
I imported it in access table and from there I exported to odbc database
some how I don't know.
After making the odbc access connection I use access odbc connection to do
my sql query and create a needed report.
Is there a way I can automate this process? to update access database from
daily text log I get?
Thanks
No comments:
Post a Comment