Hi, i got a problem importing csv files to exel 2003, i use the import wizard as recommended, the data show up but some columns are shown in date format, although everything is set to standard format. during the import it looks like low numbers show up in date format, all other do well. thanks for your help.
An expert who has achieved level 2 by getting 100 points
An expert that got 5 achievements.
An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.
An expert whose answer got voted for 20 times.
Re: importing csc files
Hi freaks11, I am DennisGladx and I hope to assist you.
This sounds like the Column of the data you want should be changed when you import the text file. Right click on the column letter, Left click on format cells from the drop down list and select the cell Con-tense you want to display.
Glad to be of assistance please rate the solution - I can learn from your rating - Thanks
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Try opening the csv file in a text editor like Notepad++ and see if there are any special characters present in the file that might normally be invisible. There is a setting to see special characters (View > Show Symbol > Show all characters).
It looks like you might have additional carriage return or linefeed characters. You could try exporting your records again and see if the csv's match.
If the column names and orders are same across files, then you can directly use the MS Excel's import data function, this will do your job.
Alternatively, if you want to do it manually, import each file in separate excel worksheet using data import wizard or simple copy paste of data (in latter case you have to use Text-to-Col feature of excel), and then manually append all figures (copy-paste in one go) to any external excel sheet.
Then finally, export/save as that external sheet to any filename of your choice.
My advice is not specific to Sage, but exoprting Excel data.
Check there are no missing/ blank cells within the range, anything that is blank change it to 0.
Make sure the format of your range matches the character length allowed in Sage - Especially for text - if necessary check the no of characters using =LEN(B2) - Assuming B2 contains the text you are checking, where necessary trim the no of characters.
Change your format to CSV if possible, sometimes easier to import.
If you do the above and receive an error message or can narrow down the issue it will give me a better idea of why the import is failing.
The key is to import the data and not open the file directly.
1. Open a Blank Workbook in Excel.
2. Data, Get External Data, Import Data. (Excel 2007 is Data, Get External Data, Data from Text)
3. Browse to your .csv file and Select "Import".
4. Import Wizard should appear.
5. Page 1 Select "Delimited"
6. Select the row which you want to start the import.
7. click "Next"
8. In the Delimiters, select "semicolon" and/or other delimiters you are using.
Note: The bottom half of the window will preview the way the data is to be imported.
9. click "Next"
10. highlight each column of your data in the window below. For each column you can specify "General", "Text", "Data", or "do not import column" using the radio buttons in the top left of the Wizard box. This is an optional step.
11. Click Finish.
I hope that helps. Please add a comment if it not clear.