What I do with Access db's is export my db table as a CSV file, open that in Excel and save as .xls so I have the exact order of column headers/spelling. Add content to that XLS spreadsheet template and export as CSV and import to the db. The workflow should work in MySQL db's.
I'm green enough to MySQL to know for sure, but it seems like it should work. On Apr 23, 2008, at 9:00 AM, John Magee wrote: > I've been trying to figure this out myself (but i'm still a novice > these days) and was hoping there was some sort of code to write to > import from excel as what i have planned will have excel files quite > often.. [Non-text portions of this message have been removed]
