[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question
[x]
Attachment Details

Saving Excel Workbooks as csv files

Asked by WJReid in Microsoft Office Suite, Microsoft Excel Spreadsheet Software, Microsoft Word

Tags: Excel, csv

I am saving Excel workbooks as csv files using VBA code. There are five fields in the spreadsheet and on all of them, the last field is blank. The files save OK, but when they are opened using for example MS Word, the first 15 records have a comma after the 4th field, but after that there is no comma. This is giving problems uploading to an Oracle Database because of the missing commas. Any ideas why this is happening? The spreadsheet is in Excel 2003,
[+][-]11/07/09 08:27 PM, ID: 25769391Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/08/09 02:16 AM, ID: 25770015Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/08/09 04:55 AM, ID: 25770323Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-92 - Hierarchy / EE_QW_EXPERT_20070906