Results 1 to 10 of 10

Thread: Unable to import excel file in Access 2007

  1. #1
    Junior Member
    Join Date
    Jun 2013
    Posts
    25
    Rep Power
    0

    Unable to import excel file in Access 2007

    I am unable to import my excel file into access that i want to analyze. Access 2007 gives error that input file not found. Access 2010 gives error start position error like this....The field contains a start position of '33120'. The maximum start position allowed is 32767.

    I am attaching the excel file for reference.

    Thanks in advance
    Last edited by excel_1317; 09-22-2013 at 11:12 PM.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    How are you importing it? Using the import data feature in Excel? or using VBA connection?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Jun 2013
    Posts
    25
    Rep Power
    0
    Quote Originally Posted by Excel Fox View Post
    How are you importing it? Using the import data feature in Excel? or using VBA connection?
    i am importing using import feature in MS Access

  4. #4
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Just had a look at your data file... Access will not let you import more than 256 columns.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  5. #5
    Junior Member
    Join Date
    Jun 2013
    Posts
    25
    Rep Power
    0
    Quote Originally Posted by Excel Fox View Post
    Just had a look at your data file... Access will not let you import more than 256 columns.
    By any means we cant import more than 256 columns? i want to make a small database, is it not possible?

  6. #6
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    13
    You will need to establish ranges and import them into two or more tables. The Access limitation is 255 columns.

  7. #7
    Junior Member
    Join Date
    Jun 2013
    Posts
    25
    Rep Power
    0
    datafile.xlsx

    Above attached is the data dump. I need to convert it into meaningful database. Please anyone help me.

  8. #8
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    13
    Your data is not normalized. You have the questions at the top with columns of potential answers. Look at this link on data normalization

    Fundamentals of Relational Database Design

    In order to input your data, you will need to have your field names at the top of your table with no blank rows between your field names and your records. You have a large scale normalization task ahead of you given the current file structure.

  9. #9

  10. #10
    Junior Member
    Join Date
    Jun 2013
    Posts
    25
    Rep Power
    0
    Quote Originally Posted by alansidman View Post
    i have read both the threads on cross posting. I promise to follow what was mentioned in those threads. The main reason for posting in this forum is we can attach sample data file.

Similar Threads

  1. Replies: 1
    Last Post: 07-25-2013, 09:03 AM
  2. Replies: 1
    Last Post: 06-18-2013, 07:46 AM
  3. Replies: 1
    Last Post: 05-22-2013, 01:50 PM
  4. Replies: 3
    Last Post: 12-20-2012, 11:10 AM
  5. Import text file to an Excel file
    By obed_cruz in forum Excel Help
    Replies: 5
    Last Post: 08-03-2011, 07:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •