Search results

  1. F

    Make table query against a normalizing select query.

    http://www.access-programmers.co.uk/forums/showthread.php?t=143986 I seem to have found a solution to normalizing Excel data at the above link. I am posting it here in case anyone else had the same questions about importing data from Excel on a regular basis in a normalized format that could...
  2. F

    Make table query against a normalizing select query.

    Thank you for your responses. I am sorry for sounding so vague. I am so immsersed in designing this database from scratch that it is getting difficult to talk to humans! :) Each week I will be importing a speadsheet from Excel. It is a listing of customer invoice transactions. Each week's...
  3. F

    Make table query against a normalizing select query.

    Greetings from Guelph! Quick question, if I import a table from Excel, normalize it in Access (which results in a select query) and then run a make table query against this new select query, have I negated the normalization I performed by turning the normalization select query back into a table...
  4. F

    Import Excel file and normalize it every week

    Scooterbug, what a great idea! I knew normalizing a new table and adding it to an existing one was something many people had to do regularly but I could not find an answer for it! Thanks from rainy Guelph! :)
  5. F

    Import Excel file and normalize it every week

    Greetings from Guelph. First, my apologies if this has been covered already. I have searched through the forum and the Using Microsoft Access 2002 and 2003 books by QUE publishing but have not found an answer. Each week I import an Excel file into Access 2002. Each week the file will have...
Back
Top Bottom