How to Import an Excel Spreadsheet Into Access With a Macro. If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true.

Flat File Import into SQL Server Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server.

I'm coming from a MS SQL Server background, where I would just create a job and import for this, and I'd be all set. I don't know MySQL well at all, so I was hoping someone could point me in the ...