+ Reply to Thread
Results 1 to 2 of 2

Excel Worksheet Export from Access Not Formatting Correctly

  1. #1
    Registered User
    Join Date
    03-27-2014
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    37

    Excel Worksheet Export from Access Not Formatting Correctly

    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.

  2. #2
    Registered User
    Join Date
    03-27-2014
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Excel Worksheet Export from Access Not Formatting Correctly

    Hi

    Further to my original post, I've decided to create a macro to format the columns prior to parsing out to the worksheets. The only problem is that I can't figure out how to write the macro so it only affects the single raw data worksheet and not all the others in the workbook.

    I know what format to use but my mind is blank on how to limit to the one sheet...below is what I have so far but it changes other worksheets. Thanks for any and all assistance.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Specifing entire worksheet as range to export sheet to access
    By UML in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2015, 05:41 PM
  2. Replies: 2
    Last Post: 05-27-2014, 10:21 AM
  3. Export Excel to Access
    By dugdugdug in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2012, 07:18 AM
  4. Opening Excel from Access, running Code in Excel then export back to Access
    By JungleJme in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2012, 08:49 AM
  5. Access Export to Excel
    By paullayton in forum Excel General
    Replies: 0
    Last Post: 03-19-2008, 02:11 PM
  6. Excel export to Access
    By MarcoR in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2006, 08:15 PM
  7. Replies: 0
    Last Post: 06-24-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1