We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Data Import

hoshie329
hoshie329 asked
on
Medium Priority
228 Views
Last Modified: 2012-05-07
I need to use vb script to pull data from a .txt file and put it in a MS Access 2003 database

i am new to this and don't even know where to begin getting the data i need from the txt file

Thanks for taking the time to help



Session Type: IPsec
 
Username     : Nymorris1              Index        : 8700
Assigned IP  : 172.16.37.19           Public IP    : .217.220.0
Protocol     : IKE IPsecOverNatT
License      : IPsec
Encryption   : 3DES                   Hashing      : MD5 SHA1
Bytes Tx     : 18163838               Bytes Rx     : 25428883
Group Policy : S&L_NY                 Tunnel Group : S&L_NY
Login Time   : 09:06:07 EDT Thu Jun 25 2009
Duration     : 5d 4h:18m:02s
NAC Result   : Unknown
VLAN Mapping : N/A                    VLAN         : none
 
Username     : nybuffalo              Index        : 15427
Assigned IP  : 172.16.36.82           Public IP    : 0.95.9.0
Protocol     : IKE IPsecOverNatT
License      : IPsec
Encryption   : 3DES                   Hashing      : MD5 SHA1
Bytes Tx     : 13089420               Bytes Rx     : 10848073
Group Policy : S&L_IN                 Tunnel Group : S&L_IN
Login Time   : 09:36:01 EDT Mon Jun 29 2009
Duration     : 1d 3h:48m:09s
NAC Result   : Unknown
VLAN Mapping : N/A                    VLAN         : none
 
Username     : nymtvernon2            Index        : 15770
Assigned IP  : 172.16.36.98           Public IP    : 0.167.178.0
Protocol     : IKE IPsecOverNatT
License      : IPsec
Encryption   : 3DES                   Hashing      : MD5 SHA1
Bytes Tx     : 5308179                Bytes Rx     : 10565827
Group Policy : S&L_NY                 Tunnel Group : S&L_NY
Login Time   : 11:52:19 EDT Mon Jun 29 2009
Duration     : 1d 1h:31m:51s
NAC Result   : Unknown
VLAN Mapping : N/A                    VLAN         : none

Open in new window

Comment
Watch Question

Commented:
Hi.

You want to put this data into a table in access?

Author

Commented:
yes this is from a cisco ASA and I can't change the format. i do need to put this in a datatbase .
 lines 3 through 13 would cover one complete entry.

Index, Hashing, NAC, Vlan Mapping, and vlan data is not needed

Thanks

Commented:
I can think of some ways to make this work, but I dont have an exact code for it so let me explain the basics:

1: Create your import specification
2: When you perform the import, you need two pieces of info: which text file to import and what table to insert into.
3: Set up the code with what text to filter out.
4: Read text from the file and put it into a String
5: Put the String into a "insert into" sql statement
6: Repeat to endOfFile

Some links which might be helpfull:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10505639.html?sfQueryTermInfo=1+tabl+txt

https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24062188.html?eeSearch=true

https://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Controls/Q_22067527.html?sfQueryTermInfo=1+from+read+txt+vba

https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20449511.html?sfQueryTermInfo=1+tabl+txt
CERTIFIED EXPERT
Top Expert 2016

Commented:
hoshie329.

attach a sample .txt file.
check Attach File below to initiate the uploading

Author

Commented:
I have attached a sample of the file i will be using.
test-putty.log
CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thank you very much, this works great.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.