Excel into Access table errors

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing an automatic via VB import of an Excel file which looks like so:

7/1 7/2 7/3 7/4 7/5 7/6 7/7 7/8 7/9
657 1740 5900 4951 2764
5975
Dates across the top and numeric values vertically down below the dates. Now the the fields in the excel sheet are set to GENERAL (taking any value entered).

The imported results looks like so:

7/1/04 7/2 7/3 7/4

7/16/1908 2821 60 1080
9/25/1918 3540 2340 2340
5/6/1907 4505 5698
8/17/1902 111 510 540

As you can see, the numeric values vertically below the 7/1 date is converted to the serial equivelant of dates. Is there a way to avoid or prevent this from happening during the import process. By the way the field types on the Access target import tablere set to text. I've also changed them to dates and numbers to no avail.

I am now at my witts end to find a solution to this problem. Anyone, with a solution can chime right in.

Thanks before hand, for all your fine assistance you render to the rest of us!
 
suggest you open your Excel file and do a Save As, to a text file. try
importing the text file into Access - you'll have much more control of the
import via the wizard.

hth


Jay said:
I am doing an automatic via VB import of an Excel file which looks like so:

7/1 7/2 7/3 7/4 7/5 7/6 7/7 7/8 7/9
657 1740 5900 4951 2764
5975
Dates across the top and numeric values vertically down below the dates.
Click to expand...
Now the the fields in the excel sheet are set to GENERAL (taking any value
entered).
The imported results looks like so:

7/1/04 7/2 7/3 7/4

7/16/1908 2821 60 1080
9/25/1918 3540 2340 2340
5/6/1907 4505 5698
8/17/1902 111 510 540

As you can see, the numeric values vertically below the 7/1 date is
Click to expand...
converted to the serial equivelant of dates. Is there a way to avoid or
prevent this from happening during the import process. By the way the field
types on the Access target import tablere set to text. I've also changed
them to dates and numbers to no avail.
I am now at my witts end to find a solution to this problem. Anyone, with a solution can chime right in.

Thanks before hand, for all your fine assistance you render to the rest of
Click to expand...
us!
 
Back
Top