importing files that increment daily

[fishy]

I have a series of excel files that we export from an application daily.
These save as example cbfile2007_03_29.csv, cbfile2007_03_30.csv,
cbfile2007_03_31.csv. I then have to import these to a database as just
CBfile and append to a master table.

Is there any way all of these can import to the one table without having to
paste them into one excel sheet and renaming?

 

[John Nurick]

Hi Fishy,

I'm not sure I understand what you mean by "import these ... as just
CBFile". If you mean that the database has been set up so it can only
import data from an Excel workbook named "CBfile.xls" and you can't get
this changed, then the only options are (a) what you're doing and (b) to
rename the files one at a time before importing them individually.

Otherwise, please explain more.

 

[fishy]

Hi,

I have the import spec for the CBfile, what I am trying to do is have this
import the first file (ignoring the date) then import the 2nd, 3rd file etc
to the same table so my queries can then run off the combined data.

 

[John Nurick]

If all the files have the same structure, you can import them all into
the same table using the same import specification, using either the
text import wizard or DoCmd.TransferText.

 

[fishy]

The import spec I have writes a new table evrytime, have you an example of
what you mean?

 

[John Nurick]

The specification does not store the name of the table or the fact you
want to import to an existing table. If you're using the text import
wizard you have to specify the existing table on (as far as I can
remember) the penultimate page; if you're using TransferText you have to
specify the name of the table.