Import from csv and add filename (2000)

Topic

New Reply

I am importing data from a csv file and would like to add an extra field to the record as it is imported containing the file name. Is this possible?

Reply | Quote

Replies

Not during a direct import. You could link the .csv file, then run a make-table query that creates a table and adds the filename field.

Reply | Quote

The name of the csv file will change between each import, so don’t think linking would be an appropriate method of data collection in this case, or am I missing something

Reply | Quote

You could write code to
– Let the user select the .csv file
– Link the .csv file.
– Run a make-table or append query (assemble the SQL in code)
– Delete the link.

Reply | Quote

Need to complete this with no user intervention. csv files are supplied by another system with the filename in format ddmmyyyyhhmmss.cvs
I would want to just run routine for filenames starting with todays date.

Reply | Quote

OK, then scrap the user prompt.

Reply | Quote