I am developing an Access 2003 application using an ADP type file with SQL Server as the back end database.
I have a routine in my application that executes a stored procedure dbo.procFlToLN which produces a result set into a table titled "dbo.tblFlToLN".
As for the file layout of the fields in table tblFlToLN
there Data Types are all "nvarchar" except 1 field that is of Data Type "datetime":
When my routine executes the following statement after the stored procedure,
I get the error:
Run-time error '3349':
Numeric field overflow.
Do you know how I can resolve this issue?
DoCmd.TransferSpreadsheet acExport, 8, "dbo.tblFlToLN", ExportedFile, True, ""