Problem with importing xls file

[filiep]

Hello, at work I want to complete the access database and therefore I donloades data from SAP to an xls file (attached). I'm trying to import the file to access 2007 and get a tabel like the result file i have attached.

If it isn't possible then is it possible to join 2 tables where I want to add data to the existing data and not only show the data of the common data

for example:

table 1:

20123 john man
20234 marie woman
20587 teddy man
20654 edith woman

table 2:

20234 hat
20587 cap

joined tabel:

20123 john man
20234 marie woman hat
20587 teddy man cap
20654 edith woman


all the help is much appriciated.

Sorry for my bad english


Filiep

 

[llkhoutx]

You can't achieve what you want directly with Access. One solution is to code it using Access VA and Excel Automation.

 

[ByteMyzer]

To accomplish what you want with Table 1 and Table 2, do a search on LEFT JOIN syntax for SQL Queries.

 

[filiep]

ok thx for the replies!