Does anyone have a method of importing a large "FLAT" CSV file into access. The file has well over 255 columns (Fields). Before anyone flames me over normalization, I do not have access to the source DB for the file and the CSV file has the data I need, but it is buried in this huge text file output from another Compan'y database. The purpose of getting it into Access is so that I can adjust it to 1st normal form, and recompute the tables in a relational format.
I can simply use the wizard to import the first 255 fields, but my issue is that I can not even see the fields beyond field 255 (at least in the wizard). I would be happy to select the few fields that I do want to import, but I don't know VBA scripting very well. Can you import the first 255 field into one table (then move or delete the unwanted fields to another table) and then append the table with the remaining fields?
Any help would be useful here... I would manually edit the text file, but is it so large the "Colum Headers" take up a full landscaped page in notepad.
The file does have text headers above the data, and I know the specific names of the headers.
Thanks,
John
4  6472 
Hi, John.
255 is a limit for number of fields in table. There is nothing to do here. On the other hand you may have 1 memo field in your table, import or link csv row-per-record for example and then parse it to individual substrings into a normalized (of course) set of tables.
Kind regards,
Fish
Hi, John.
255 is a limit for number of fields in table. There is nothing to do here. On the other hand you may have 1 memo field in your table, import or link csv row-per-record for example and then parse it to individual substrings into a normalized (of course) set of tables.
Kind regards,
Fish
I assume you mean dump all the data (i.e. rows) into a single "Field". RIght? Wa shoping for a more elegant solution, but I think it may work. I will have to append the data every month...ug.
Thanks Fish
Not at all.
Actually I don't see more elegant solution so far.
Maybe somebody else.
Best regards,
Fish.
NeoPa 32,556
Expert Mod 16PB
Don't forget the Split() function when parsing the data. It can save much headaches ;)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Edward S |
last post by:
I budget for a Project in an Excel sheet as illustrated below. The
months below are usually a 2 year period i.e. 24 months, though it
could be over 24 months depending upon a Project. I then...
|
by: Darren |
last post by:
I have been attempting to create a reservation planning form in excel
that imports Data from an Access database and inserts that information
automaticly into the correct spreed sheet and the...
|
by: Elena Ghetti |
last post by:
I have a large 49,000-record table from Excel I would like to import to
Access(2002 but the same happens also with XP 2003), mostly text and
memo fields. When I use the import wizard, fields are...
|
by: jillandgordon |
last post by:
I am trying to import an excel file into Access 97. It looks perfectly all
right but, every time I try to import it, I get to the lst step and am told
that it was not imported due to an error. ...
|
by: hharriel |
last post by:
Hi,
I am hoping someone can help me with an issue I am having with excel
and ms access. I have collected data (which are in individual excel
files) from 49 different school districts. All...
|
by: Debbiedo |
last post by:
I have a text file that I am importing into an Access table that was
generatred from data exported from a Word file. Several (about 20-30)
fields are from check boxes on the Word form. These fields...
|
by: Kosmos |
last post by:
Hey guys,
I'm fairly familiar with access by now, but I've never worked with importing text into an access database. I have some fairly large text files (lets say, for example, a folder of 20 text...
|
by: captainphoenix |
last post by:
Windows XP Home Edition
VB 2005
MS Access 2003
I am having problems importing mdb information from access to visual basic. The first application worked fine, but the second one refuses to work,...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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
|
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...
|
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...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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...
|
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...
|
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,...
| |
