Results 1 to 2 of 2
  1. #1
    The Stig is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010

    Exclude rows to get to data/field names

    I've got a HUGE database to create. I have 60 GB worth of excel files or so I need to combine and the first 6 rows are things such as company name, which machine created the spreadsheet and so forth. The field names are on row 6. How do I make it so the wizard knows my fields names are on row 6 and the data needed starts on row 7? I would go into the original files and delete them, but I'm not allowed to manipulate the data, not to mention it's 60 GB worth of files and that alone would take forever.

    Also side note, When I combine two spreadsheets in a query, will the database understand to put a N/A or whatever in the value if one spreadsheet has an extra field name?

  2. #2
    dsmacs is offline Advanced Beginner
    Windows XP Access 2010 (version 14.0)
    Join Date
    Oct 2009
    Perth Western Australia
    The Access Wizard does not have the funcunality to look at row 6 for column headings. You will need to either copy the files and delete the top 5 rows or import without column names into a temporary table and then append to you table exluding data in top 6 rows.

    Side note - When you set up your table/s you need to include all the field names possible from the data in the excel files.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-17-2010, 12:21 PM
  2. Exclude records within same criteria
    By brooke48 in forum Queries
    Replies: 14
    Last Post: 05-15-2010, 02:15 PM
  3. Verify CSV Field Names Before Importing
    By johnson in forum Import/Export Data
    Replies: 2
    Last Post: 01-26-2010, 06:53 PM
  4. Replies: 7
    Last Post: 12-11-2009, 01:44 AM
  5. Quick way to stuff field names into text field
    By kfinpgh in forum Programming
    Replies: 0
    Last Post: 01-04-2007, 01:13 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums