transfer data from excel with constants

  • Thread starter Thread starter eighthman11
  • Start date Start date
E

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
 
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
 
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
 
Back
Top