Error while importing data to excel file

[Rutajit]

Hi,

I am facing an issue when i am trying to connect , MyODBC driver 3.51.12 with Excel 2007.I am facing this issue when i try to use MS Excel with Mysql Connector/ODBC3.51.12 and at the same time i am getting an error message which says [MySQL][ODBC 3.51 Driver]User cancelled.

Can anyone solve this error message for me.

[Macarenas]

Make sure you haven't made any changes in your field name when your import, if are doing so then first delete the data and then try import it again.In other words, i don't think that Access will assume that Column1 goes into Field1 etc.

[Rutajit]

I have try to do that too but still getting [MySQL][ODBC 3.51 Driver]User cancelled .Can anyone tell me how to over some from this error message.

[amit shah]

Try to use the following steps for importing your data to excel :-

1. Open Excel and select Data from here select External Data and Import Data.
2. Now select New Source from Select Data Source dialog.
3. Select ODBC DSN and then select the odbc data source from database and table Finally select Finish with saving the file with .odc
4. It will ask you for do you want to import data over here select OK and import data.
5. Now Connector/ODBC dialog will get appears with a username.
6. Finally enter correct user name and select OK from Connector/ODBC dialog.