I.T. Discussion Community!
-Collapse +Expand
Search Access Group:

-Collapse +Expand Access To/From
-Collapse +Expand Access Store

Prestwood eMagazine

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

   ► MB LobbyMicrosoft Access BoardAccess VBA Programming Topic   Print This     

Help with CSV file creation using VBA

Help with CSV file creation using VBA in Access VBA Programming topic (part of our Microsoft Access group).

Quick Search: creation   CSV   CSV file   creation using  
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??

I will be giving the file to another who needs it to read as a string without having to format it in Excel because I believe the formatting is general and is treated as scientific in excel if it is above a certain size.

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

 Posted 18 years ago (Thread Starter)
Comment Quote
About dibbler -Collapse +Expand
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 #5837, 1 replies
Thread Started 4/13/2002 10:58:00 PM
View Counter=1130
Last Reply Posted 4/15/2002 6:59:00 AM)
Joined=18 years ago   MB Posts=2  
Most Recent Post
i have 2 suggestions...one is create a macro in Excel to change the column to text, or the second would be to insert a " " or some other text character either to the beginning or the end of the barcode

select " " & barcode as barcode

this should make excel view the cell as text
 Posted 18 years ago
Comment Quote
About jdschram -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #5842 (Level 1.1)  Reply to 5837
Thread Started 4/15/2002 6:59:00 AM
View Counter=2
Joined=19 years ago   MB Posts=259  

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 = P167A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #5837 Counter
Since 4/2/2008

Follow PrestwoodBoards on: 

©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech