Re: DDS to Excel ?

With that being said, what is an easy way to import a excel spreadsheet
worth of data that is a mismatch to the DDS that it is to populate. 34
field types are correct, types of data in the fields is different.

Dr.UgoGagliardelli wrote:
jacko wrote:
In DDS I have a field defined as S, 9 and 0, what is the S equivalent
in excel.

S is not a data type, is an encoding option of a numeric data type. the
notation S 9 0 means that the field can hold a number with 9 maximum 9
digits with no decimal digits and can be positive or negative.
Since excel knows only float and small integer as numeric data type, you
should specify float, even if s 9 0 is an integer, but exceeds a small
integer capability. So you you can define a number with 0 fixed decimal
positions.

--
Dr.Ugo Gagliardelli,Modena,ItalyCertifiedUindoscrasherAñejoAlcoolInside
Spaccamaroni andate a cagare/Spammers not welcome/Spammers vão à merda
Spamers iros a la mierda/Spamers allez vous faire foutre/Spammers loop
schijten/Spammers macht Euch vom Acker/Spamerzy wypierdalac'

.

Relevant Pages

  • Re: Importing alphanumeric cells from Excel - havent yet seen a t
    ... However the data type option of the Import Spreadsheet Wizard is ... IIRC if you format an Excel cell as text and then enter a formula, ... text seldom makes any difference to the importing. ...
    (microsoft.public.access.externaldata)
  • Re: Question - problem importing data from Excel spreadsheet
    ... comparison of the data in the Excel sheet and Access data table. ... If it finds any text data type in the rows it scans, ... You will get the error message that you posted. ...
    (microsoft.public.access.externaldata)
  • Re: INSERT into named range using ADO
    ... Excel also uses Jet and exhibits the same behavior for INSERT INTO i.e. ... Without a header row, Jet uses default columns ... Note the data type of the new ...
    (microsoft.public.excel.programming)
  • Re: type conversion failure
    ... >> EXCEL spreadsheet, so it assigns a number data type to that field, and ... >> <MS ACCESS MVP> ... >>>>>I am impoting a excel spreadsheet into my access database as a new ...
    (microsoft.public.access.externaldata)
  • Re: linking or merging to Excel
    ... you can do the EXCEL save as via Automation. ... the data type is correct. ... Otherwise, you could use Automation to open the EXCEL file, read each row ... prior to importing but it still imports as a number. ...
    (microsoft.public.access.gettingstarted)