Union Query Maybe?

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

Guest

Hi, I don't know if this is possible but here goes.....

Database been created to log incoming mail to be tracked, some users would
like to use excel to input the data and have it merge into the main query.

Possible problem: the database table/query creates a LetterID using
<autonumber> for each piece of mail that is logged as several users will be
entering mail in each morning.

I agree with your first thoughts, have them use Access instead, but I need
an option if they cannot use it.
 
Create a "transfer" table that has the same field layout as the excel
spreadsheet.
Create an Append query to append data from the transfer table to the table
with the autonumber. Do not include the autonumber field in the append query.

Then, to get the data in:
Delete any data in the transfer table.
Import the spreadsheet into the transfer table using Transferspreadsheet.
Run the append query.
When it appends records to the table with the autonumber field, an
autonumber will be assigned to each record.
 
Back
Top