transfer data from excel with constants

[eighthman11]

Using Access 2003.
Hello everyone. I need to insert data from a spreadsheet to a table
but I also need to insert some constants for each record that gets
inserted from the spreadsheet. Any ideas appreciated. Without going
into much detail -- linking the excel spreadsheet is not an option.

Any help appreciated.

Thanks Ray

 

[Jeff Boyce]

How do you plan to get at the spreadsheet? Importing data and linking to it
are two common (but closely related) options. Are you using another
approach?

If I had to add records to a table from data stored in a spreadsheet, I
would:

1. link to (or import) the spreadsheet, as is (assumes the spreadsheet
ONLY has data)
2. build one/more queries designed to parse the raw (spreadsheet) data
into well-normalized tables
3. add any constants to those queries
4. run the query(ies)

NOTE: if this needs to happen more than once, how will you "get" the new
spreadsheets/data?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[eighthman11]

How do you plan to get at the spreadsheet?  Importing data and linking to it
are two common (but closely related) options.  Are you using another
approach?

If I had to add records to a table from data stored in a spreadsheet, I
would:

    1.  link to (or import) the spreadsheet, as is (assumes the spreadsheet
ONLY has data)
    2.  build one/more queries designed to parse the raw (spreadsheet) data
into well-normalized tables
    3.  add any constants to those queries
    4.  run the query(ies)

NOTE:  if this needs to happen more than once, how will you "get" the new
spreadsheets/data?

Regards

Jeff Boyce
Microsoft Office/Access MVP








- Show quoted text -

Hey Jeff - thanks for the response.
I'm going to create a new thread with more details. Hopefully someone
has some ideas