SqlDbx Forum

khsaunderson

Member

Import excel file not working

When I try to import an excel file into a newly created table, it doesn't appear to work.  I just get a garbled message opening in a new query window (see below).

ÐÏࡱá66969943The Twang36829Robin Sadio Edit)56327rsion)mimnd Kardiynter) (Radio Edit)o Edit)94523D0974374lde World (Radio Edit)um Version) (Clean Versi(ou Wot! (Radio Edit) (Feat. MC Bonez)gue_No
tBinOrientation






þÿþÿ
R

To import the excel file I am right clicking on the table, selecting 'import data from', then selecting 'file'.  The excel field is the same name as the table, as are the column names within the file.

Any help would be much appreciated.

Thanks

sqldbxhelp

Administrator

Re: Import excel file not working

Can you please send this excel file to support@sqldbx com if possible.

khsaunderson

Member

Re: Import excel file not working

Thanks - I have emailed a sample of the excel file I am trying to upload.

khsaunderson

Member

Re: Import excel file not working

Thought I should write the solution to this so that other people can see where I was going wrong...

How to import data from an excel file

1. Open sample.xls in Excel

2. Select data area, eg A1:I3

3. In SqlDbx click on a table with the same columns as in Excel and select "Import Data From"

You should see menu item "Excel - sample.xls". Select it.

All of the individual insert statements are now added to a new script and you can simply run it (F5) from there.

Last edited by khsaunderson (2010-02-16 09:31:59)

Miguel

Guest

Re: Import excel file not working

And, what is the format for the datetime columns, in the import?

But in my import, the date fields, only apear NULL.

sqldbxhelp

Administrator

Re: Import excel file not working

There's no specific requirement for date format in Excel.
Excel should recognize cell value as date and table column data type should be date or timestamp