I need help with an error made entering data.

[raycatena]

I entered approx 900 records into a field that I thought was a table.



Is there a way to salvage all of my input?

Can I for example Export the data into Excel (2007) and then Import it into a new Table in a new data base?

It is a Street index with two fields, The Street Name and the Grid on the map. (Ie Main Street & S-7)

Thanks for any help on this

Ray

[June7]

I don't understand how records could be entered into a field mistaken as a table.

Without understanding more about the data and the error, hard to say what would be feasible approach to fix. However, will say yes, can export and reimport or might be able to run INSERT or UPDATE SQL actions and avoid Excel altogether.

[ItsMe]

If you want, I can take a look at what you got via Remote Assistance. No charge for a little advice.

[CJ_London]

you could perhaps have an update query to split the data if there is a clear pattern e.g.

UPDATE myTable SET StreetName= Left(streetname,len(streetname)-4), Grid= Right(streetname,3);

[ItsMe]

you could perhaps have an update query to split the data if there is a clear pattern e.g.

That's what I was kinda thinking but I am curious how all of this was accomplished and if the data is intact.

[CJ_London]

it's happened to me in the past - typically importing a .csv file where the first row has a different number of columns from the main data- so Access assumes the whole file is a single column. the csv file often comes from the 'big boy' systems such as sap and the first row contains some sort of file identifier and the second row the headers e.g.

F, SAP Report 123 dated 3/5/2015
H, heading1, heading2, heading3,......
D, 12,33,xyz,.....
D, 12,45,abc,.....
D, 13,43,fgh,.....
E, End of Report

[ItsMe]

...where the first row has a different number of columns from the main data...

Nice ... ...

[CJ_London]

hmm, Excel can be just as bad - someone sends you a file and they use two rows for the headings - the first row perhaps using merged cells

This Month, Last Month

and the second row

Budget, Actual, Variance, Budget, Actual, Variance

So now you also have columns with duplicate names.

and then of course next month, they decide to pretty the file and have the first column blank so they can see the border they have put round the data

etc etc