Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - importing text

Reply
 
Old 08-10-2009   #1 (permalink)
Bre-x


 
 

importing text

Hi,
I need import data on a csv file to an ODBC table

I would really apreciate if someone will give me some pointers.

Thank you all

Bre-x



My System SpecsSystem Spec
Old 08-10-2009   #2 (permalink)
Paul Randall


 
 

Re: importing text

Using only VBScript to parse CSV files is a royal pain. ADO is a
VBScriptable tool you probably have on your computer that can do most of the
work for you. Groups.Google.Com allows you to search specific newsgroups,
such as this one, so that you can get a fairly small list of useful hits.
One very useful hit I found was the following link, in a post by
ekkehard.horner; he has made many posts over the years, with working
VBScript examples, on converting between CSV text files and Excel & Access
files:

http://groups.google.com/g/78d7fef5/...e1d1ccb7d868fb

Groups.Google also allows you to specify an author which can be handy when
you know a likely source of useful info.

-Paul Randall

"Bre-x" <cholotron@xxxxxx> wrote in message
news:O7CPsJeGKHA.4620@xxxxxx
Quote:

> Hi,
> I need import data on a csv file to an ODBC table
>
> I would really apreciate if someone will give me some pointers.
>
> Thank you all
>
> Bre-x
>
>

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Looping Through A Text File To Find Patterns From Another Text Fil PowerShell
Importing text file to Access Database VB Script
MVP's, text to speech!!, Can I dictate in other text input program Vista General
Howto: Add lines of text from a specific point in a text file.. VB Script
How do I read a text file and sort text by fixed positions? PowerShell


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46