Solved

Use a SQL statement to import text files

Posted on 2007-11-15
4
178 Views
Last Modified: 2010-03-20
I am currently using 'DoCmd.TransferText' to import text files using the import specifications to bring the text files into a table.  Is there a way to import text files without using the DoCmd function?
0
Comment
Question by:TBayXXXV
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 20289591
You could write your own file handler in VBA using the filesystemobject.

Why is transfertext a problem?
0
 

Author Comment

by:TBayXXXV
ID: 20289621
In the future, the code is going to get converted to .net and I'm told that .net doesn't support the DoCmd function.  I was asked to look for an alternative.
0
 
LVL 77

Accepted Solution

by:
peter57r earned 125 total points
ID: 20289762
.net doesn't look anything like vba.
Nothing you write will convert to .net.


0
 

Author Comment

by:TBayXXXV
ID: 20290007
I see.  Ok, thanks.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question