Update Access Database from Excel Spreadsheet

[icpsvt]

I think I got myself over my head here.

First off - I'll explain what I know.
SQL - Have a really good understanding of it, but haven't used it too much, so I'm sure there's room for improvement, but I don't think I need it here.
VBA - Don't know a whole heck of a lot about it. At all.

What I need to do:
I'll be getting information in the form of Excel Spreadsheets. It'll have a person's firstname, lastname, and what classes they have taken.
I need to get that information into an Access database.

How do you go about doing that? Any good tutorials one would recommend?

Thanks for any and all help.
-Jason

 

[TomCologne]

That shouldn't be very difficult. For details look into VBA Help,

TransferSpreadsheet Method

Syntax

DoCmd.TransferSpreadsheet [transfertype][, spreadsheettype], tablename, filename[, hasfieldnames][, range]

Just follow the description, fill in your data and run the DoCmd.

There are several ways to do that, I find this method rather convenient and it helped me a lot to get at least an idea of VBA.

Create a form in Design View,

make sure that you have the control wizards button (magic wand) on

Click on the Command Button icon and insert a button into your form, the wizard starts and offers some options, choose, ie "Record Operations>Add New..."

Click through the wizard windows, click 'View Code' and, in the VBA window, replace the

DoCmd line with yours.

If you want to go from there and play around a little more with code options, do it on a copy of your db. Or even better, use a copy from the start.


TomCologne