Import text file with mapping to data table

[Zdz16]

Hi to all;



The question was asked more than once , and there were several answers. However I can not find a solution to my 'little' following question :
I would like to import data from a text file with a separator ";" whose first line gives the names of the fields in the destination table . And with the following options that are available to the user :
1 - The imported data will replace all data in the destination table . (remove all / Import all)
2 - Only new data is added
3 - Only the new ones are added , and if the data ( The key enregistremen ) Similar exist, they will be updated by the imported data
4 - update only the existing data in the table.

Import report should be generated

The concern I have
I can not do the mapping between the columns in the import file and the table and use it.
I do not know how to match data types Import / Table ( Knowing that the import is in text format ?)
Find the primary key and the load to achieve the 'find' in the destination table to apply the options ( below desssus )

So, if you have suggestions , ideas I'm interested.

Thank you to all of you cordially

[orange]

A few comments/questions:

1- research Import Specifications
2- where is the input data coming from ?how is it created?
3- how many tables do you use this data input technique for?
4- have you considered bring the data into a tempTable and using a form to get user parameters, then based on selection execute the appropriate action query
5- have you considered other options for inputting data?

[Zdz16]

Thinks for your replay;

1-2 The data come from filing a separate application files on a server. On this side, I have no worries. However, the fact that these applications are independent, the order of columns may be changed. That is why I want make a mapping between the structure of these files and the table.
3 - The table number is not a problem, since import is on a table at a time by the user.
4 - Yes, I thought of this solution. But this step can be avoided if we can do the mapping procedures.
5 - Not for the data processing, because the number of records are many and the user should not spend his time doing data entry

What I want is to find an example of VBA code that performs the import data with mapping.

Best regard