469,126 Members | 1,281 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

importing a csv to access 2007 using vba

Hi,
I import a csv file to an access table using the following code as a part of a larger code:
Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferText acImportDelim, , strTableName, strPath & objFile.Name, True 
Prior to the import, I imported the table manually, so that I have a base table to import to.
Every time I import, I delete the data from the access table and import the new one onto it.
It works fine except for the fact that one of the columns has values of '0' most of the time and sometimes changes to '0.1'.
For some reason the column is always imported as '0'.
I tried to define the column as Double, Decimal, or even text, and nothing works...
Any ideas anyone?

Thanks in advance,
Izhar
Oct 25 '10 #1
0 993

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by ABinBoston | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.