Invalid Argument while importing

[Mary]

My office upgraded to Office 2000 recently -))

Now when we import a huge billing file (fixed width .txt)
gets an error message.
"Invalid Argument"
After a few tries the data gets imported !!!!

Had no problem while we were using Access 97

Please help

 

[Amy Vargo]

Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

and if the table contains a field with a data type of Number and a field
size of Decimal, you may receive the following error message


Invalid argument.


followed by:


An error occurred trying to export data from table '<tablename>'. The
data was not exported.

To work around this problem when you export the data, select Save formatted
in the Export Table dialog box.


-or-

Create a query and use the appropriate conversion function (for example,
CDbl, CSng, CInt, and so on) on the field defined as Number with a field
size of Decimal.


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

 

[Guest]

Thanks Amy,
Where can I get more information on Conversion Functions?
I am not familiar with it.

"

Create a query and use the appropriate conversion function (for example,
CDbl, CSng, CInt, and so on) on the field defined as Number with a field
size of Decimal.

"

 

[Amy Vargo]

Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

The Help topics do not group these functions together. You can look up
each function individually. Look in VBA Help under "CDbl" (Convert to
double), CSng (Convert to single), or CInt (Convert to integer).

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.