×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel97:Exporting from Excel to an Ascii File?

Excel97:Exporting from Excel to an Ascii File?

Excel97:Exporting from Excel to an Ascii File?

(OP)
Hi,

I need help exporting an Excel multiple spreadsheet to an Ascii File.  Any suggestions?

Also, I am importing an excel spreadsheet
into Access and I am getting import errors;
Type Conversion Errors (#num!). I change all fields to text.  And I am still getting errors.

Sample data:
v1234
234.0
234.00
*v1234
411.1

I would greatly appreciate any suggestions.

Thanks

RE: Excel97:Exporting from Excel to an Ascii File?

What is the asterisk for? In Access, it means any character--I don't think it likes it! You'll need to pull this character out, I think.


dreamboat@nni.com

RE: Excel97:Exporting from Excel to an Ascii File?

Dreamboat is correct about the asterick, Access will have issues importing that record (or that field of that record).

as for exporting an Excel file to Ascii, i know that you can only export 1 worksheet of a spreadsheet at a time when exporting to a .txt file.

are you jsut using the Save As function, or are you trying to do it through code?

Brian Famous
bfamous@ncdoi.net

RE: Excel97:Exporting from Excel to an Ascii File?

(OP)
Hi Brian,

 Congrats! Thanks for your help last week.  I am trying to convert Excel into an Ascii File using code.  I figured out the type conversion issues.  I set all columns in Excel
to General format and all data types in Access to text.  Do you remeber the question I
ask last week about importing multiple Excel worksheets into an Access table using
VBA code only?  You, replied that to use the range, but was not confident.  I tried, and it does not work, do you have any other suggestions?

DoCmd.TransferSpreadsheet acImport, 8, "multisheets", MyValue, True, "A1:J200"

Thanks

RE: Excel97:Exporting from Excel to an Ascii File?

there are only two things i can think of.

1.go through the trouble of putting each worksheet in a seperate spreadsheet, and then just repeating the code and replacing the name of the spreadsheet in each instance.

or

2. (and i don't know for sure if this is possible), Find a way to designate which worksheet within a spreadsheet to get the data range from.  where you have "A1:J200" put something like "Sheet1!A1:J200"  you'd then have to repeat the code again, with everything being the same except for the range - this may work, but i have yet to try it.  let me know if it does though.  

Brian Famous
bfamous@ncdoi.net

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close