Member Avatar for JoyBh

I'm successfully importing a .dbf table into access using the get external data wizard. The issue is the data structure of the imported table. For instance, a filed with num(5) in .dbf will appear as double (without any field length) in the imported table in access. This limits onward use of the data in other platforms.

Joy

  • 2 Contributors
  • 1 Reply
  • 81 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by boblarson
Member Avatar for boblarson

Set up the table to be imported to first with the right datatypes and all and then import the data.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.