Import Excel file to SQL table
Posted on 2002-05-26
I receive an Excel file from a client on a daily basis that must have all of its records, in some (but not all) columns imported / appended into my SQL server, via ODBC. I need to do this via DAO, as ADO (ect) is not available right now (if that's important). I need to do this within an existing DAO based application.
I have -VERY- limited knowledge of OLE, etc. I'm pretty good at VB, in general, but there seems to be precious little information on how to do what I'm asking for. I know this should be simple, but for the life of me, I JUST DON'T GET IT!
Am I even asking the right questions or presenting the problem correctly??? I've tried MSKB and can't seem to come up with the right combination of answers.
HELP, please! Source is the best way for me to understand. If you respond, expect that I'll ask LOTS of questions!!!