If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
populating an Access table from a text file
A text file has data in a format like the below:
Title1 Cell 1 data Title 2 Cell 2 data Title 3 Cell 3 data .. .. .. Title 10 Cell 10 data Title 11 Cell 11 data .. .. .. Title 15 Cell 15 data .. .. .. Title N Cell N data I guess I can read this using some VBA code posted at http://www.mvps.org/access/modules/mdl0057.htm and http://www.granite.ab.ca/access/readtextfile.htm, add an Instr function to it so that when I read the text file, I know when to insert the data properly in the table. 1. Is there another way I can directly import the data into an Access 2007 table without VBA code? I know Access allows import from data, but my data is not as formatted as I want so the data might end up being in the table in a way such as Field 1 of Access Table Title 1 Cell 1 Title 2 Cell 2 .. .. .. Title N Cell N whereas I want it to be like Field 1 Field 2 Field 3...................Field N of the Access table Cell 1 data Cell 2 data Cell 3 data 2. If I have to use VBA, are the methods I linked to proper(Am i going in the right direction) and advisable or are there better/easier ways to do what I want to achieve. Any advice would be welcome. |
Thread Tools | |
Display Modes | |
|
|