I'm new to importing in MS Access and need some assistance. I have create a brand new DB and called it TESTME. I have a .TXT file with 121 rows of data. I need to section it out using FIXED LENGTH options because the data needs to be separated in a certain fashion. I know the data types that need to be applied to each field. Here is a sample of my data:
2111111111122006020914572107492426 200505261111005992420060110NA 0000000225 5 1201920 NA
2111111111122006020914572109559636 200506281111004682320060110NA 0000000151 8 2501800 NA
2111111111122006020914572111049445 200511182111001332320060106NA 0000000336 6 3300480 NA
2111111111122006020914572112729192 200512151111003552420060109NA 0000000156 8 1501000 NA
2111111111122006020914572112846809 200510281191001103120060201NA 0000000447 7 4400990 NA
2111111111122006020914572113140329 200509141111002352320060111NA 0000000225 5 1200780 NA
2111111111122006020914572113792065 200509141111002202320060110NA 0000000225 5 1200800 NA
2111111111122006020914572114407646 200509091111001362420060105NA 0000000255 8 2500420 NA
2111111111122006020914572115314179 200509211111001502420060119NA 00000002225 5 1200800 NA
I am using data types: integer, date/time, text for certain ranges of data. After I go through all the steps in the Import Text Wizard, I click the FINISH button and an error window pops up saying "The Microsoft Jet database engine could not find the object ". Make sure the object exists and that you spell its name and the path name correctly. An error occurred trying to import file 'C:test.txt'. The file was not imported.
I'm not using VBA or macros and just trying to do it manually. It seems simple enough but I know there is something that I'm missing. Can anyone help?
Thanks in advance.