Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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 February 10th, 2004, 10:29 AM
Registered User
 
Join Date: Jan 2004
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default CSV or Text file As a Report Record Source

Hi I wish to use a CSV file or text file as my source for a report,
I have discovered the Input # Statement for accessing the file inside VBA code however I am confused how to make this file the record source for a report so I can use Accesse's reporting features. Any help would be appreciated.

Thanks Rick

 
Old February 10th, 2004, 07:37 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Just link to your csv file.
go to file
get external data
link tables
then select the file and link it. It will run slow, but it should work.



Sal




Similar Threads
Thread Thread Starter Forum Replies Last Post
changing Text source file names rjjhome SQL Server DTS 1 August 18th, 2004 02:27 PM
extract the crystal report to csv file in c# prune_3_16 General .NET 1 August 9th, 2004 09:09 PM
extract the crystal report to csv file in c# prune_3_16 Crystal Reports 0 August 9th, 2004 09:03 PM
CSV or Text file As a Report Record Source rickf Access VBA 0 February 12th, 2004 10:16 AM
csv file data source q's kap260 Classic ASP Databases 0 August 4th, 2003 04:17 PM





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