Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old November 25th, 2010, 07:54 AM
Registered User
Join Date: Nov 2010
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default import txt into table vba

Ho bisogno di aiuto per generare del codice vba che mi legga un file txt dal disco e mi crei una tabella di access,
Old February 18th, 2011, 05:50 AM
gjgriffith's Avatar
Wrox Author
Join Date: Jul 2009
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default Importing Text

(In English)
Hello Gerry,

I saw your post, I don't speak Italian, but I've translated this with Google Translate. I hope you can understand it.

If you can get your Text in XML format, you can call the code:

Application.ImportXML "C:\MyData.xml"

Also, I recommend providing an XSD in this data if possible, otherwise, you will need to have it in a format that Access will recognize.

Does this help? Please let me know if you have more questions!
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++
(In italiano)
Ciao Gerry,

Ho visto la tua nota, io non parlo italiano, ma ho tradotto questo con Google Translate. Spero che tu possa capire.

Se è possibile ottenere il testo in formato XML, è possibile chiamare il codice:

Application.ImportXML "C:\MyData.xml"

Inoltre, vi consiglio di fornire uno schema XSD in questi dati, se possibile, in caso contrario, sarà necessario avere in un formato che Access sarà riconoscere.

Questo aiuto? Per favore fatemi sapere se avete altre domande!
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++

Good Luck,

Geoffrey L. Griffith

Wrox Author of:
Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference
Old February 23rd, 2011, 08:34 PM
Registered User
Join Date: Nov 2010
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Import file txt into table access

Appending table access must be from a file "*.TXT ", though not always calls the same way and not always in the same directory path, then I must be able to choose both the .txt file to the directory from which to append

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import a fixed width txt file to access subhanak Access VBA 12 May 5th, 2006 05:35 AM
Import a Comma separated txt file to SQL table arielote C# 2 April 17th, 2006 01:08 AM
Get table records into Txt or CSV format kapi.goel SQL Language 0 April 10th, 2006 01:47 AM
Import txt starting at a specific line lookin VB How-To 5 March 29th, 2006 11:53 AM
DTS - import txt , no order rows luma SQL Server DTS 2 July 14th, 2005 11:32 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.