Welcome to MacForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

importing space and comma delimited file

  
   Macintosh computer (Home) -> Excel RSS
Next:  Office Home 2007 Upgrade to Pro for Access  
Author Message
Noah Garrett Wallach

External


Since: Oct 17, 2007
Posts: 1



(Msg. 1) Posted: Wed Oct 17, 2007 2:18 pm
Post subject: importing space and comma delimited file
Archived from groups: microsoft>public>mac>office>excel (more info?)
Hi there,

1) what are the steps to import space delimited file?
2) what are the steps to import comma delimited file?

Cheers,

Noah

 >> Stay informed about: importing space and comma delimited file 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 2394



(Msg. 2) Posted: Wed Oct 17, 2007 2:18 pm
Post subject: Re: importing space and comma delimited file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In article ,
Noah Garrett Wallach wrote:

> 1) what are the steps to import space delimited file?
> 2) what are the steps to import comma delimited file?

One way:

Unlike WinXL (which will auto import files with the.csv extension), you
can use File/Open, then follow the Text Import Wizard (choose Delimited,
click Next, check Space or Comma, then click Finish

To import into a current workbook, choose Data/Get External Data/Import
Text file... and follow the same steps.

 >> Stay informed about: importing space and comma delimited file 
Back to top
Login to vote
TMc

External


Since: Mar 25, 2008
Posts: 1



(Msg. 3) Posted: Tue Mar 25, 2008 9:14 am
Post subject: Re: importing space and comma delimited file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
USING A IMAC, I HAVE A WEBSITE, NEED TO IMPORT CUSTOMER INFO IN MYOB FIRST EDGE ACCOUNTING SOFTWARE.
IT WAS EMAILED TO ME USING EXCEL AND FORMAT COMMA-SEPERATED, WOULD NOT IMPORT GAVE AN ERROR MESSAGE

"Error -4: First digit of Account Number must be 1,2,3,4,5, or 6."
Error -185: Account Type is too long or contains invalid characters.

I CONTACT MANUFACTURER OF MYOB AND THEY SAID THAT IT NEEDS TO BE DOUBLE CARRIED TO BE IMPORTED WHAT DOES THIS MEAN

THANK YOU TO ANY AND ALL THAT CAN HELP ME
 >> Stay informed about: importing space and comma delimited file 
Back to top
Login to vote
SUPPORT_OUR_TROOPS!

External


Since: Mar 25, 2008
Posts: 2



(Msg. 4) Posted: Tue Mar 25, 2008 9:42 am
Post subject: Re: importing space and comma delimited file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
IS THIS FOR A MAC COMPUTER I'M NOT SURE WHAT YOUR ANSWER IS
 >> Stay informed about: importing space and comma delimited file 
Back to top
Login to vote
SUPPORT_OUR_TROOPS!

External


Since: Mar 25, 2008
Posts: 2



(Msg. 5) Posted: Tue Mar 25, 2008 9:44 am
Post subject: Re: importing space and comma delimited file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]