example of txt import

**liebor** · 03-08-2011, 04:28 AM

I have say 1000 records each having at least the 'Name:' and 'Country:' field. They are separated by an empty row in a TXT file- example of 2 records:

Name: Balatti, Michel

Company: Blaalb
Website: http://birkintree.com
Email: michelbalatti@tiscalinet.it
Screen Name: Michel
Address: Savona,
Country: Italy

Name: Banis, Mr Jan
Email: jbanis1@gmail.com
Country: Ireland

How would I populate a database in access. Thanking you for a hint.

**RuralGuy** · 03-08-2011, 06:46 AM

I would just use VBA and the Input # command and walk through the file.

**liebor** · 03-09-2011, 04:32 AM

Originally Posted by RuralGuy

I would just use VBA and the Input # command and walk through the file.

Thanks for caring for the forum...
Will the result be not automatic ie. one would just need to see all the records to control the input process?
Will you suggest a place with VBA tutorials
Thanking you

**RuralGuy** · 03-09-2011, 09:08 AM

Crystal has some good tutorials: http://www.accessmvp.com/strive4peace/
We can help you with the code if you want to learn but it takes a bit of time.

example of txt import

Thread Tools

example of txt import

does walk suggest some crawling

Similar Threads

Import from .CSV or .TXT

Batch import .txt

Import value from one form to another

CSV vs XLS Import

How would I import something like this?

Posting Permissions