Welcome to Egypt Forums Mark forums read | Egypt Main Page
Egypt Forums
Arabic Movies



Software and Programs A place where you can share links to Windows applications , Adobe , Microsoft , Rapidshare , Megaupload..

Software and Programs Thread, Importing a Fixed Width Text File into Access using VB in Software & Hardware , Games; So I am completely new to VB and coding. As in I understand the logic and understand how to read ...

Short Link: http://forum.egypt.com/enforum/showthread.php?t=25650


Reply
LinkBack Thread Tools Display Modes
Importing a Fixed Width Text File into Access using VB
 
 
Senior Member

Reply With Quote
 
Join Date: Dec 2008
Posts: 18,122
05-02-2009, 07:40 PM
 
So I am completely new to VB and coding. As in I understand the logic and understand how to read it, i just cant write it (much like how I am with Spanish, go figure) Anyways, I have a relatively simple project I am working on but it is tough for...

So I am completely new to VB and coding. As in I understand the logic and understand how to read it, i just cant write it (much like how I am with Spanish, go figure) Anyways, I have a relatively simple project I am working on but it is tough for me because I suck at writing code.

Basically I have a file that is fixed width.

My Issue: dealing with a standard file that contains headers and footers as well

I am assuming I would need to write something that would say open file, etc, etc, then it would state to read in the first line and after that there would be a Do While Not EOF loop but it would need to be NOT EOF +1 because I would need to end the loop at the 2nd to last line so that I can read in the footer as well. I know that I can do this simply by doing an import spec in access but the incoming file will frequently change so I need to do it in VB so that I can modify the columns and add in new data etc. So if someone could basically help me with a simple coding framework, how to first read in the file, how to read in the first line of data, then create the loop, read in the whole line (because I can then write it specifically to my file), and how to do the footer, I know I can do the rest. I am one of those people who works well off of examples so Im just looking for a good blueprint/framework from someone. Your help is greatly appreciated. Thanks.
 
 
 
Reply

Software and Programs Thread, Importing a Fixed Width Text File into Access using VB in Software & Hardware , Games; So I am completely new to VB and coding. As in I understand the logic and understand how to read ...

Short Link: http://forum.egypt.com/enforum/showthread.php?t=25650


Bookmarks

Tags
access, file, fixed, importing, text, width


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump