Import from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JetDave - 27 Jun 2007 16:02 GMT

I've been running a Macro that Imports from Excel. After the Import runs one
of my field data types is changing from text to number and I'm losing data.
My Import Spec, Table, and the Excel File all have text data types before the
Import but after my table is a number. Any thought on how I can fix this?

Signature

Material Logistics DBA

Reply to this Message

Chris Reveille - 27 Jun 2007 20:56 GMT

Add a dummy record to the Excel file for the first record with the correct
data types. You can delete that record after the import
or
Import into an existing table with the correct filed types

Signature

Chris

> I've been running a Macro that Imports from Excel. After the Import runs one
> of my field data types is changing from text to number and I'm losing data.
> My Import Spec, Table, and the Excel File all have text data types before the
> Import but after my table is a number. Any thought on how I can fix this?

Reply to this Message