473,396 Members | 1,773 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

MS Access 2007/2003 Import Wizard Maximum Number of Fields

I tried to read in a text file with fixed width using import wizard on both versions of MSAccess (2003/2007).

I created a table for the data and then started the tedious job of adding all fields to the map.

When I click the advanced button for the first time there are a number of rows and some automated assignment (the table has 215 columns). The initial assignment does not capture all table columns.

When I try to add more fields, the import wizard complains that index out of range, which leads me to believe that somehow there is a maximum number of columns that is smaller than 215.

Is that true? Can one circumvent this limitation?

Right now I created a stored procedure to read line by line and load it into the table but that is very slow.

Thanks,

Marco
Jun 17 '10 #1
0 1487

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: meandean | last post by:
Is there a limit to how big a dataset can be? im at 270 fields and im getting a error is this a limmit? thanks meandean
2
by: pendell | last post by:
I am working with a client running 2003 Access. Some time ago I built them an import spec for use with the Import Wizard. Several months later, I have been called back and asked to solve a...
4
by: EHOHP | last post by:
Access 2007 on XP Pro Each record contains two fields - StID (a unique ID number) and Pic (an attachment field to hold a jpg). Is it possible to create a batch import that places the picture in the...
0
by: Gary | last post by:
I'm having trouble entering Additional Registry Keys into my Package Solution that will deploy the Access 2007 runtime. (Client machine is running XP with Office 2007 Standard.) The Package...
1
by: taila | last post by:
Hello everyone on this forum, I have recently started learning how to use ACCESS 2007 to create databases for work purposes. I ran into a problem while creating a form. Here's the message that...
9
by: prakashwadhwani | last post by:
Hi !! I'm about to develop a new project for a client. Should I go about it in Access 2003 or 2007 ? Purchasing it either for me or for my client is not a major consideration here ... what I'd...
2
DAF LAD
by: DAF LAD | last post by:
Hi. I have been running an access Database in Office 2003 for a while now. When I upgraded to Office 2007 one of my macro buttons has stopped working. The Button looks up to VBA code to Import...
9
by: shalskedar | last post by:
Access can store how many maximum number of records for a db.. Wanted to know what is the limitation of total number of records that Access db can store
1
by: pascalph20 | last post by:
About 4 years ago I set up a multi-user Access database which I now maintain in Access2007, but which the users still access through 2003. It is a single instance mdb, regularly reorg'ed, low...
2
by: rywags11 | last post by:
Hello, Can anyone help me figure out how to show/hide fields based on information entered in other fields in a form in Access 2007? What I'm looking to do is: When a selection from a drop down is...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.