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.
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
i am importing using import feature in MS AccessOriginally Posted by Excel Fox
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
By any means we cant import more than 256 columns? i want to make a small database, is it not possible?
You will need to establish ranges and import them into two or more tables. The Access limitation is 255 columns.
datafile.xlsx
Above attached is the data dump. I need to convert it into meaningful database. Please anyone help me.
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.
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.
Posting Permissions
Reply With Quote
Bookmarks