Web Development

Ask something
Discussion Locked

Excel Data-->Access Database Environm

0 helpful
3 replies

by xpertdragon 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am sure by many developers standards, this is a popular subject/topic. I am looking for resources online that document, help, explain, and even examples of How Excel Spreadsheets and workbooks can be MIGRATED over to Access 2000 (Office 2000).
I am preferably looking for "Online Books" that have chapters that discuss this popular migration, but general web documented diagramming will also work great.

I am required to get a lot of Excel data into a Database file, which can have Forms for inputs of additional info as well as query generated reporting and such. I assume that going as far as using Visual Basic would not be necessary, but I believe Forms, and Reports can be easily created within Access with the wizards.

Any help on this popular, but not well documented data migration would be greatly appreciated. Thanks you very much!

Paul M. Chavez

3 replies

by joseph moore

Actually, pulling data into Access from an Excel spreadsheet is pretty easy.
On your spreadsheet, make sure it has column headers.
Then open the Access database you want to import this data into, click File -> Get External Data -> Import.
A browse window comes up. In the File Type drop-down, choose Microsoft Excel, then browse to your spreadsheet and click OK.
The import wizard will then show you a grid of the spreadsheet, and you will have several options over the next few wizard steps to fill out. Things like stating that there are column heanders, defining the data types per column, and if you want to import or skip individual columns.
The most important step is the Primary Key step of the wizard. You can choose to have Access add a Primary Key column, or if it should use an existing column with unique data per record.
Eventually, you will click an Import button, and watch the import fly on by!
When done, you will have a table (which you can name during the wizard) with yourspreadsheet's data.

hope this helps

This discussion is closed to new replies.