SQL Excel Conversion

  • Thread starter Thread starter NJ Excel
  • Start date Start date
N

NJ Excel

I am having trouble converting excel to SQL. The columns i am having trouble
with are Text columns, but most of the data is dropped and only data that is
alphanumeric is converted. I would like to know how to fix this. If i
change the alphanumeric data to numeric, that is the only column converted,
all the other numberic fields are null.
 
I am having trouble converting excel to SQL.  The columns i am having trouble
with are Text columns, but most of the data is dropped and only data that is
alphanumeric is converted.  I would like to know how to fix this.  If i
change the alphanumeric data to numeric, that is the only column converted,
all the other numberic fields are null.
Click to expand...

You may want to convert to Access as an intermediate step. Excel can
be a bit odd in conversion.

My methodology is usually to try (from Access) File->get external data-
link which is great when it works but frustrating when if missclasses
Click to expand...
text and numeric columns. If I see those problems I'll try a straight
import, which works 95% of the time. If that doesn't work I'll build
the table in Access and cut and paste from Excel. From there it's a
simple task to export to SQL Server, Oracle, or whatever.

hth,

Tim Mills-Groninger
 
I am having trouble converting excel to SQL.
You may want to convert to Access as an intermediate step. Excel can
be a bit odd in conversion.
My methodology is usually to try (from Access) File->get external data-
text and numeric columns. If I see those problems I'll try a straight
import, which works 95% of the time. If that doesn't work I'll build
the table in Access and cut and paste from Excel. From there it's a
simple task to export to SQL Server, Oracle, or whatever.
Tim Mills-Groninger
Click to expand...
Totally agree with you Tim. Although Access does cost additional $$$,
there are a couple of advantages. I found the most useful thing when
copy+pasting from Excel into Access is that Access will tell you which
lines are causing the problems. There are normally only a couple of
records that cause the problems and it is a really quick just to
manually fix them afterwards.

Phil
 
Back
Top