Toad for MySQL - Community for development, administration, tuning, tips and tricks

Forums » Beta

Thread: Tools > Import > Import Wizard does not import numeric data from Excel file

This question is answered.

Reply to this Thread

Search Forum

Back to Thread List

	Replies: 2 - Pages: 1 - Last Post: Sep 20, 2011 10:03 AM by: Catahoula Kelpie	Threads: [ Previous \| Next ]

Catahoula Kelpie

Posts: 6
Registered: 2/18/11

Tools > Import > Import Wizard does not import numeric data from Excel file
Posted: Aug 30, 2011 6:45 PM

I discovered a bug trying to import data from an Excel file. All the numeric based data is missing from the "File Preview" step of the wizard and sure enough the numeric data is also not imported.

This applies to integer and decimal data.

The workaround is to import the data as a csv file but it would be great if this bug was fixed so that the import works with native Excel files in case the data contains commas that throw off the alignment of data to columns.

Kiki

Posts: 121
Registered: 4/5/10

Re: Tools > Import > Import Wizard does not import numeric data from Excel file
Posted: Aug 31, 2011 10:53 AM

in response to: Catahoula Kelpie

Answered

I cannot reproduce the issue, could you send your Excel to us for more investigation?

Catahoula Kelpie

Posts: 6
Registered: 2/18/11

Re: Tools > Import > Import Wizard does not import numeric data from Excel file
Posted: Sep 20, 2011 10:03 AM

in response to: Kiki

Thanks Kiki for replying. I just tested this again with version 6.0 GA and the issues appears to be fixed. Thank you!

Pages: 1

Back to Thread List

Threads: [ Previous | Next ]

Legend
	Guru: 2001 + pts
	Expert: 751 - 2000 pts
	Enthusiast: 31 - 750 pts
	Novice: 0 - 30 pts
	Moderators
	Helpful answer (5 pts)
	Answered (10 pts)

Toad World

Downloads

Welcome, Guest