Newbies dbyers Posted October 19, 2000 Newbies Posted October 19, 2000 I'm trying to document my solution, and need to export my field definitions to an Excel spreadsheet (or any other delimited format.) Presently the only way I can output my field definitions is to print them. Thanks in advance, David
WBlanchard Posted October 19, 2000 Posted October 19, 2000 Select a single record from your db file, and export it as a DBF format. Then open it in Excel and the Field name will be on the top row. HTH
Newbies dbyers Posted October 19, 2000 Author Newbies Posted October 19, 2000 Thanks for your reply. Problem is that I want all of the field definition specifics in my report (ie field type, relationships, etc.) David
danjacoby Posted October 20, 2000 Posted October 20, 2000 This might not help, but... If you have Acrobat, you can print to a PDF file. Of course, doing something with it after that is problematic, but you can create a hyperlink from Excel or Word to the PDF file (assuming you have a recent version of MS Office; 97-98 should do it). Dan
Chuck Posted October 20, 2000 Posted October 20, 2000 quote: Originally posted by dbyers: I'm trying to document my solution, and need to export my field definitions to an Excel spreadsheet (or any other delimited format.) Presently the only way I can output my field definitions is to print them. Thanks in advance, David I'm not real familiar with the program, but Print2Pict might be able to help you out, and I think it's freeware. Basically it can print the field definitions to a text file, which you could then bring into Excel. Chuck
MadHatter Posted October 20, 2000 Posted October 20, 2000 if you export to "Comma-Separated Text Files .. *.csv" file then it will open up in excel. ------------------
danjacoby Posted October 21, 2000 Posted October 21, 2000 quote: Originally posted by MadHatter: if you export to "Comma-Separated Text Files .. *.csv" file then it will open up in excel. Problem is, he wants the field definitions; exporting to a .csv will just export the data.
Newbies dbyers Posted October 23, 2000 Author Newbies Posted October 23, 2000 I ended up printing them out, then scanning them back in with OCR & manually placing them in the desired cells in Excel. Unfortunately I had to do this in over 30 files - not fun. Thanks for all of the suggestions, though.
Chuck Posted October 24, 2000 Posted October 24, 2000 quote: Originally posted by dbyers: I ended up printing them out, then scanning them back in with OCR & manually placing them in the desired cells in Excel. Unfortunately I had to do this in over 30 files - not fun. Thanks for all of the suggestions, though. Really, try out Print2Pict. I think this can do the job for you. I can print to a text file, which you can then bring into Excel. You can avoid the whole scanning and OCR operation. You might also be able to avoid it by printing to PDF and using Acrobat to OCR the file so that you don't have to print and scan. Chuck
Recommended Posts
This topic is 9048 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now