Import Excel to Access Data

[PHP_Adam]

Hello All

I have a Excel data which looks like
Name | Address Line 1 | Address Line 2 | City | Postcode

Then I have Database looking like this:
Name | Address

How can I Import data from excel to access, and merge all the address data?

Im useing Microsoft Office Access 2007 and Excel 2007

 

[Ron_dK]

I would say :
Import the excel data in a new table ( e.g. Table1).
Table1 has 5 fields.
Make a query based on table1 which looks something like :

SELECT Table1.[Field1], Table1.[Field2], Table1.[Field3], Table1.[Field4], Table1.[Field5], ([Field2] & " " & [Field3] & " " & [Field4] & " " & [Field5]) AS Adress
FROM Table1;

Copy the Address data to your existing table in the Address field.


Hth