Import CSV file and add data to records

[shmoussa]

I've seperated my three questions to keep this organized. Basically I
am importing a CSV file using an open dialog box.....

Now, my already existing table has 5 fields, and my CSV file has 4
fields. Before the data is imported, is there a way to create a popup
window asking the user to enter the date that the CSV file was
generated and use that date as the fifth field for all of the new
records being added from the CSV file? I hope I explained this
question the right way. Please let me know if it isnt clear.

 

[Guest]

If you are using TransferText to import the data, you will have to change a
couple of things. You will need to either link to the csv file or import it
into a temporay table (I recommend the link). Then you will have to have a
text box on a form to accept the date. Then use an append query that has the
four fields from the csv file and a calculated fifth field that references
the text box on the form.

 

[Guest]

if you want reliable ETL then you shoudl move to SQL Server and use DTS or
BCP

Access Data Projects are a great interface for SQL Server; I highly
reccomend moving it to the next level (of performance and reliability)

 

[Guest]

Your response is totally out of context, has nothing to do with OP's
question, and frankly, is nonsense.
If you have something pertenant and useful, please contribute it.