Excel to Access

[ASharifs]

Hi

I am trying to convert some Excel files to Access: File > External > Import etc. I have already built Access tables and relationships.

The problem is: The Excel report I have corresponds to fields from diffrent Access tables. How can I export them to diffrent tables ?

The other problem is that the Excel table is a 'flat' report. For example the Field 'Transportation' in Access may contain three diffrent combo options: car, train, or ship, and each will have its own frequency figures. On the other hand this information in Excel appears as three diffrent cloumns with diffrent cities as raws. For example a cloumn titled 'train' has 10 values for 10 cities, similarly 'car and ship' .. while all the three belong to only one field called 'Transportation'. They get segregated ( similar to the existing Excel report ) only when generated as Access reports.

Is there any way to export these three Excel cloumns into one access field ?

Please help ..

 

[neileg]

I would deal with the import and the manipulation separately. Either re group your data in Excel and import that, or import the data as it is, and use some queries to extract what you need.

If this is a one off import, I would favour doing the manipulation in Excel. If it's going to be a regular thing, use queries in Access.