PDA

View Full Version : Unable to import excel file in Access 2007


excel_1317
09-17-2013, 10:54 PM
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
Excel Fox
09-17-2013, 11:21 PM
How are you importing it? Using the import data feature in Excel? or using VBA connection?
excel_1317
09-17-2013, 11:24 PM
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
Excel Fox
09-17-2013, 11:29 PM
Just had a look at your data file... Access will not let you import more than 256 columns.
excel_1317
09-17-2013, 11:35 PM
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?
alansidman
09-21-2013, 01:53 AM
You will need to establish ranges and import them into two or more tables. The Access limitation is 255 columns.
excel_1317
09-22-2013, 11:10 PM
1240

Above attached is the data dump. I need to convert it into meaningful database. Please anyone help me.
alansidman
09-23-2013, 01:17 AM
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 (http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx)

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.
alansidman
09-23-2013, 01:21 AM
Cross posted at: Access data import query (http://www.mrexcel.com/forum/microsoft-access/727196-access-data-import-query.html)

http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/#post5326
excel_1317
09-23-2013, 07:52 AM
Cross posted at: Access data import query (http://www.mrexcel.com/forum/microsoft-access/727196-access-data-import-query.html)

http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/#post5326

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.