I’m using MS Access 2003 on my computer to import .csv files and export them as fixed-position .txt files. (I’d save them as .txt from Excel, but Excel doesn’t have an option to write fixed-position text files with the record lengths that I have; so I have to use Access.) My coworker manually enters data into the AS 400 computer. It writes a file in a certain format. The AS 400 is going away as of today, so she needs to enter her data in Excel. Right now, she saves the Excel file as comma delimited. I do the Access import/export and run the data through a program. I don’t want to do this. I want her to do it. The trouble is, that she doesn’t really know how to use a computer.
She has Access 2010, and I don’t know how to use 2010. In 2003, I create a database by choosing New and Blank database. Then I click a button on the toolbar to import a file. Then I click a button to export the file. Easy-peasy. In 2010, I don’t see how to do that. How do I do in 2010, what I do in 2003?