Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » ADO
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
ADO
Resolved · Medium Priority · Version 2003
Reply Fri 7 Nov 2008, 16:07Delegate Ian said...
Ian has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
ADO
how do I get the connection string to a csv file
For upcoming training course dates see: Pricing & availability
RE: ADO
Hi Ian
Thank you for your question
It is possible to connect to a csv file. The code however is rather involved and there are a number of additional concepts that you need to understand; as a result providing a full answer is beyond the scope of the forum.
I have found the following web page that provides some sample code that you might find useful.
http://www.vb-helper.com/howto_ado_load_csv.html
I have not however tested the code, so you should use it with caution.
We can if required provide further assistance, although this would be on a consultancy basis
Regards
Stephen
Thu 4 Dec 2008: Automatically marked as resolved.
|