G
Guest
I have been importing a txt file into my database for years. My work program
now has been updated and the file is now in an Excel Spreadsheet. When using
the import wizard for a text file I was able to create an import spec that
handeled the formatting and renamed each column to match my database. When
using the import wizard with excel the wizard does not allow me to either use
an import spec or import the file using the field format used in my database.
My question is how can I do this using Excel?
now has been updated and the file is now in an Excel Spreadsheet. When using
the import wizard for a text file I was able to create an import spec that
handeled the formatting and renamed each column to match my database. When
using the import wizard with excel the wizard does not allow me to either use
an import spec or import the file using the field format used in my database.
My question is how can I do this using Excel?