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 6502 FishVal 2,653
Recognized Expert Specialist
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
FishVal 2,653
Recognized Expert Specialist
Not at all.
Actually I don't see more elegant solution so far.
Maybe somebody else.
Best regards,
Fish.
NeoPa 32,578
Recognized Expert Moderator MVP
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 need to
input this in an Access database, where I do a comparison with the
Actual cost. The table “TblBudget” in Access is made of 4
fields, namely: (1) CostElement (2) CostCenter (3) Month (4) Amount$.
At the moment this method is very cumbersome....
|
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 correct cells within
that worksheet. The Excel Book is made up of 12 worksheets named
Jan-Dec. Each worksheet has columns labeled as each day of that month.
Column 'A' is reserved for 19 rows named "room1 - room19". The data I
am importing from 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 correctly
recognized, but then, when checking the resulting table I found that
most large fields (from 400 chars to 6000 chars) were truncated
somewhere after approx 390 chars (so larger than the 255 max chars for
text fields). This is not...
|
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. There is no further explanation.
What are the kinds of things that make this happen?
Thanks from an obvious rookie.
Gordon
|
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 districts have used the
same excel template and populated the same 32 data fields (columns). I
created one large excel file from all 49 files which gives me a master
table of 60,000 or so records. I have tried to import this master
table into access...
| |
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 have either
0 (Not checked) or 1 (Checked). Due to requirements from a third party
software application, they HAVE to be either Y(Checked) or N (Not
checked) and MUST be a text field in the Access table.
I will be importing several thousand of...
|
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 files could be about 120 mb with each text file being 6 mb). I know that Access has some strict limitations on fields and their sizes and I've learned to stay away from using memos. The files are encoded health files and so they have a '~' to...
|
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, giving me a list of build errors pertaining to " not defined..." see below
Error 1 Type 'AirlineReservationForm.Sennello_06DataSet' is not defined. C:\Documents and Settings\msennel1\Desktop\hw6\Airline...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |