Then I go back to 'Data' -> 'Connections' -> 'Properties' -> 'Definition' Tab -> 'Edit Query' then reset to start at row 1 and click finish and it worked. ![]() I want the header information but I first set up the import stating at row 7, set the import type for each column and run. On the wizard page, click Save import steps or Save export steps to save the details of the operation as a specification. WORKAROUND SOLUTION (BTW: "Using Excel 2010") After you click OK or Finish, and if Access successfully completes the operation, the Save Import Steps or Save Export Steps page appears in the wizard. Even more strangly it has successfully done it on one of the. ![]() TXT files before and Excel has picked up the table header row without problems but for some reason it is now having trouble on this file. I've done the same plenty of times with these MYOB. It is treating the MYOB account codes as dates which is causing no end of headaches. I normally get around this using VB script in the worksheet, but I still would like to. In Step 2, Default to Comma, and in Step 3 I want the Date format to default to YMD. In Step 1, I want to default to Delimited. I need a hack that will pre-set some of the selections in three Wizard steps. On the Import Wizard it is only showing me two columns (which matches the document header information in the equivalent of A1 and B1) so I can't set the third column to "TEXT" instead of "GENERAL". I open a lot of Comma limited files in Excel using the Text Import Wizard. It has some document header information in the first six rows then the table header and the data. ![]() ![]() I have a related problem and I have discovered a work around solution.
0 Comments
Leave a Reply. |