Importing question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello, I am a database where the user has 2 files, that it is going to upload
everymonth. My questions are
1) I need a way to have the user save the file onto a specific table but
will have a chance to save it with a different name each month. For instance,
i have a file "April 05", then when i select that file, i want to import to
the table and the press save and it is going to prompt the user to type in a
name

2) I made an append query. Now it only recognize the file name i created
before. So right now it is only focusing on April 05. Now next month comes,
and i have to manually type in the new file name. Is there a way so that once
the user selects the file, imports to the table, then give it a name --> i
want to have that "name" be link to the file name automatically so that I
don't have to manually adjust it.
 
if the tables are the same - fieldnames, data types - then you shouldn't
import each month's data into separate tables. instead, put all your file
data into a single table. add a field to the table for MonthAndYear - or
perhaps a complete date, if that's appropriate. there are various ways that
you can "fill in" the correct month/year to that field as you append each
new file's data into your table.

hth
 
Back
Top