Printable View
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
How are you importing it? Using the import data feature in Excel? or using VBA connection?
i am importing using import feature in MS AccessQuote:
Originally Posted by Excel Fox
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?Quote:
Originally Posted by Excel Fox
You will need to establish ranges and import them into two or more tables. The Access limitation is 255 columns.
Attachment 1240
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.Quote:
Originally Posted by alansidman