Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Convert data from rows to columns | Excel Discussion (Misc queries) | |||
Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
analysing data from alternate columns using the countif function | Excel Discussion (Misc queries) | |||
Macro to Synchronize data frm svrl workbooks & columns to 1 workbo | Excel Discussion (Misc queries) |