Notepad Records

  • Thread starter Thread starter Gator
  • Start date Start date
G

Gator

How do I pull records from Notepad...for example, pull records from notepad
where field criteria matches a selection from a form list so I can see a shot
of a total amount before selecting another criteria from the listbox.
 
Assuming your Notepad file is arranged in columns so it can import correctly,
use the TransferText method.
 
I'm not sure how to do this...any help?

"For a fixed-width text file, you must either specify an argument or use a
schema.ini file, which must be stored in the same folder as the imported,
linked, or exported text file. To create a schema file, you can use the text
import/export wizard to create the file."
 
Yes, you use the Import/Export wizard. It would be File, Get External Data,
Import. When you get the file dialog, select Text Files and navigate to the
file. When the Import wizard opens, click on advanced. There you can choose
the columns to import, set their data types, and choose whether to import
each column. When that is done, click on Save As and save it with a name.
Then in the TransferText method, you identify the specification name.

Once that is done, you can code the TransferText and use the spec name.
 
Back
Top