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

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

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

ok thx for the replies!