Hi Everyone,
I'm working on a automation process that will be pulling a csv file, placing the data into a table with the current date. I want to export the table into another database, but how do I do that since the date will always be changing? The coding below shows the import csv file and table process.
Public Sub ImportFile()
Dim strPath As String
Dim strTable As String
Dim strSpec As String
DoCmd.SetWarnings False
strPath = "C:\Documents and Settings\XXXX\Desktop\CB_Feed_Upload\CB_UPLOAD.csv"
strTable = "tblMasterFile" & Format(Date, "YYYYMMDD")
strSpec = "ImportSpec"
DoCmd.TransferText acImportDelim, strSpec, strTable, strPath, True
I need to export that table into another database, but the name will appear like this "tblMasterFile20120515". Am I able to utilize a keyword such as tblMasterFile?
Thank you in advance.
I'm working on a automation process that will be pulling a csv file, placing the data into a table with the current date. I want to export the table into another database, but how do I do that since the date will always be changing? The coding below shows the import csv file and table process.
Public Sub ImportFile()
Dim strPath As String
Dim strTable As String
Dim strSpec As String
DoCmd.SetWarnings False
strPath = "C:\Documents and Settings\XXXX\Desktop\CB_Feed_Upload\CB_UPLOAD.csv"
strTable = "tblMasterFile" & Format(Date, "YYYYMMDD")
strSpec = "ImportSpec"
DoCmd.TransferText acImportDelim, strSpec, strTable, strPath, True
I need to export that table into another database, but the name will appear like this "tblMasterFile20120515". Am I able to utilize a keyword such as tblMasterFile?
Thank you in advance.