-Collapse +Expand
Access
Search Access Group:

Advanced
Access To/From
To/FromCODEGuides
Access Store
PRESTWOODSTORE

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardAccess VBA Programming Topic   Print This    All Groups  

Help!! I have a problem with CSV files using VBA i

Help!! I have a problem with CSV files using VBA i in Access VBA Programming topic (part of our Microsoft Access group).

Quick Search: problem   problem   problem CSV   files using   VBA i  
Most Recent Post
dibbler
UK
Hello,

Could anyone help with this problem, I am developing an App using VBA and I create a query and then print # line by line to a Comma Seperated Value file, .CSV, one of the fields is a barcode thats 13 chars in length e.g. 9732781902314 , when I open up the CSV file in Excel, the format is scientific i.e. 9E+05 etc.. and I need it to treat it as a string but it thinks its a number. The field in Access is a text field??

It is giving me a major headache!!, thanks.

Jason
 Posted 24 years ago (Thread Starter)
Comment Quote
About dibbler
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #5833, No Replies Be the first!
Thread Started 4/13/2002 10:48:00 AM
View Counter=1218
Location=UK  
Joined=24 years ago   MB Posts=2  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P193A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #5833 Counter
1218
Since 4/2/2008
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2026 Prestwood IT Solutions.   [Security & Privacy]