How To Import Excel File To Ms Access, No Header

Hi,


I have a table named EMPLOYEES.

The fieldnames are Name,Surname, MiddleName, Age, Gender, Department.

I also have an excel file that needs to be imported to table EMPLOYEES.

The headers are Name, Surname, Middle Name, Age, Gender.

If you will notice , field Middle Name have space compared to MiddleName in the MS Access table EMPLOYEES.


How can I import the "CONTENTS" of an excel file only to the database?

Ah yes the Access gods are sooooooo helpfull when importing Excel into Access. They assume that don't need to change ANYTHING, especially the field name or the data type.

I'm not entirely clear on what you are asking so here are my answers.

1. If you are asking simply if an Excel spreadsheet can be imported into Access then the answer is yes. File > Get External Data then either Import or Link. You will need to change the File type at the bottom of the dialog box to .xls.

2. If you are asking about importing directly into your employees table, I don't think you can. You must either import or link the Excel data to append it to an existing table.

3. If you are asking how to import an Excel file and modify the Field name ( or data type for that matter) I have always exported the Excel file to a .csv or other format and then done the import since you can control the field names etc when doing this type of import.

4. If this is something you need to regularly and are asking how to get the data from the excel sheet to your employees table I would recommend you link to the Excel sheet (see #1 above) and then create an append query. In the append query you can specify which fields go where so the name differece won't be an issue.

If you are asking about something else, please be specific.