LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Ben Amada
 
Posts: n/a
Default

Dave O wrote:

Just a guess he when I create a table in Access I can specify field
width for my entries. Is it possible the field width in your DBF file
is set to some default value that is comparitively low?

I just tested this by saving some Excel text as a DBF (DBase IV
format). The only database program I have on this computer is Access,
so I opened the DBF file using Access and found the file width to be 9
characters- but I couldn't alter the field width because Access had
attached the data rather than import it. Do you have software that can
alter the field width?


Hello Dave,

Thanks for testing that out. I do have Access although I generally don't
use it.

I was able to create a new database in Access, import the Excel file into
Access and then Export the data from Access to a DBF file. Also, since I
imported the data (rather than "attach" it), Access allowed me to alter the
field lengths although it wasn't necessary since when I import the data,
Access must automatically detect the longest field of data and set the field
length to that value.

In short, your idea of using Access got me on the right track!

Thanks again,
Ben


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Convert data from rows to columns boksic Excel Discussion (Misc queries) 4 July 4th 05 11:40 AM
Text to Columns / Importing Data John Thomson Excel Discussion (Misc queries) 0 May 4th 05 08:21 PM
analysing data from alternate columns using the countif function Juniper Excel Discussion (Misc queries) 3 April 28th 05 04:12 PM
Macro to Synchronize data frm svrl workbooks & columns to 1 workbo jbsand1001 Excel Discussion (Misc queries) 1 April 28th 05 10:42 AM


All times are GMT +1. The time now is 08:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"