Template for a import (1 Viewer)

[ct2013]

Hi there,

I am about to start creating a db where the client wants me to afterwards make a template which at the click of a button in a form they will be able to select that file and it will directly import it into the correct fields i set it to.

Is this poss and if yes can you please advise, send examples or links.

Thanks

 

[CJ_London]

if your table has the same fields (names and types) as the import file you can use transfertext to append to the destination table.

if the field names are different or need to be calculated in some way the easy way would be to import the data into a temporary table (using transfertext) and then run a query to append the data from the temporary table to the destination table - both these actions can be run off the same button on a form

In both cases I would initially import your data manually using the appropriate option on the external data tab - this will then create the import specification for you