copy csv files (2000)

Topic

New Reply

I have a csv file called c:datainput.csv, which I process into a table then delete. Before the processing, how can i copy it to another file using a name which includes the date and time eg. c:datastorefile-01012004-1640.csv

Reply | Quote

Replies

Use the following :
Name “c:datainput.csv” As “c:datastorefile-01012004-1640.csv “

Reply | Quote

Or even better if you don’t want to put in the date and time every time:

Name “c:datainput.csv” As “c:datastorefile-” & Format(Date, “ddmmyyyy”) & “-” & Format(Time, “hhmm”) & “.csv”

Reply | Quote

Thanks for the replies – only just got round to checking them out.
The Name File1 As File2 works fine – but I need to make a COPY, not simply rename the file – any other thoughts?

Reply | Quote

Use the FileCopy command.

Reply | Quote

Use the FileCopy command.

Reply | Quote

Private Sub Command1_Click()
Dim iNme As String
Dim oNme As String

iNme = “C:DataInput.csv”
oNme = “C:DataStoreFile” & “-” & Format(Date, “ddmmyyyy”) & “-” & Format(Time, “hhmm”) & “.csv”

FileCopy iNme, oNme

End Sub

Reply | Quote

many thanks

Reply | Quote

many thanks

Reply | Quote

Private Sub Command1_Click()
Dim iNme As String
Dim oNme As String

iNme = “C:DataInput.csv”
oNme = “C:DataStoreFile” & “-” & Format(Date, “ddmmyyyy”) & “-” & Format(Time, “hhmm”) & “.csv”

FileCopy iNme, oNme

End Sub

Reply | Quote

Thanks for the replies – only just got round to checking them out.
The Name File1 As File2 works fine – but I need to make a COPY, not simply rename the file – any other thoughts?

Reply | Quote

Or even better if you don’t want to put in the date and time every time:

Name “c:datainput.csv” As “c:datastorefile-” & Format(Date, “ddmmyyyy”) & “-” & Format(Time, “hhmm”) & “.csv”

Reply | Quote

Use the following :
Name “c:datainput.csv” As “c:datastorefile-01012004-1640.csv “

Reply | Quote