Welcome to MacBoardz.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 1:45 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: 3054



(Msg. 2) Posted: Wed Oct 17, 2007 1:45 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:   
Related Topics:
importing space and/or comma delimited file - How might I import a space delimited file into excel? How might I import a comma delimited file into excel?

Saving in comma delimited format - When I import a list of contacts in a comma delimited format that=20 works fine. Then I try to save it in a comma delimited format, I see = that=20 everything is in columns, which I think it should be. Then when I come=20 back and open the file again the...

Commas remain after saving as tab-delimited when importing.. - I can't seem to import my excel database without gaining commas. I have repeatedly saved the worksheet as a tab delimited format and then imported them into entourage. Yet, even after going back in and removing all commas from the excel sheet and then....

Can't save Mac Excel to usable tab-delimited text file - I need to do what I would think is a simple thing: save a Mac Excel file (Office 2004 version 11.2.5 using OSX 10.3.9) to a tab-delimited text file [TDTF] (to import into Final Cut Pro). (1) My default Excel file has three sheets. If I try to save this....

Opening/Importing a csv file in Excel v.X - Hi, I cant open a csv file in Excel. I have tried File Open, and Import TextFfile. The file is always dimmed. I also tried Get Info/Open with, and the Excel option is dimmed. I'm using Excel SR1 and OS X 10.2.8 any ideas anyone? Vicktor
   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 ]