ADO with Excel and text file as DATA

		Wrox Programmer Forums > Microsoft Office > Excel VBA > BOOK: Excel 2000/2002 VBA Programmer's Reference
ADO with Excel and text file as DATA

BOOK: Excel 2000/2002 VBA Programmer's Reference

This is the forum to discuss the Wrox book Excel 2000 VBA: Programmers Reference by John Green, Stephen Bullen, Felipe Martins, Brian Johnson; ISBN: 9780764544019

Read more about Excel 2000 VBA: Programmers Reference or buy the book from your favorite retailer
Download the code for Excel 2000 VBA: Programmers Reference

Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel 2000/2002 VBA Programmer's Reference 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

December 15th, 2004, 06:57 AM

Joelelapin2 Joelelapin2 is offline

Registered User

Join Date: Dec 2004

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

ADO with Excel and text file as DATA

Hello,

I want to make an Excel application from a data file.
My problem is my delimiter caracter wich is not ";" but "|" and ADO understand the complete line as only one field.
How can I parameter my microsoft.jet.oledb.4.0 to change this delimiter.

Sample : Name|Data1|Data2|

Thank for your help.

Joe.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get data from Excel file using ADO.NET	lam_lvl	ADO.NET	7	February 27th, 2014 05:19 AM
Problem getting Excel data with ADO 2.7	xoc	Excel VBA	2	April 18th, 2007 09:37 AM
Transferring data from text file to Excel	imranshah	Excel VBA	0	July 5th, 2006 10:22 AM
import data from text file to excel(VBA)	topr	Excel VBA	2	August 26th, 2004 11:36 PM
Update Excel File Using ADO .Net	briancronin123	ADO.NET	0	June 3rd, 2004 02:20 AM