Hello
I have a database in Access and I have tried multiple methods to get the data from Access to Excel including using the import from access wizard. I've also tried exporting to Excel and then copying and pasting that worksheet into the workbook I'm working on. In all instances, even though the field that looks like a number in Access but is formatted as text in Access, is imported as a number.
The data from Access, where one line of data is a single abstract, is imported into Excel as one worksheet (raw data) and then a macro runs to place the data elements of each abstract into a certain cell per worksheet....so 10 abstracts, 10 worksheets representing each abstract.
Even if I format the column on the raw data worksheet as text, it still copies into the new worksheet as a number. The raw data worksheet has many columns that stretch to column KF. I could create an import wizard macro to define what format each column should be but if the source data changes that might be a pain to update. Because many columns in a row are text, it would probably be easier to create a macro to change all the formats on the raw data worksheet but I'm not sure where to start with that.
Can anyone suggest what they think would work best and give me some direction on where to start? Thanks so much.
Bookmarks