Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exported spreadsheet contain ' (Excel 2000)

    I have a

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exported spreadsheet contain ' (Excel 2000)

    It seems that every bit of data is declared as text. I don't know much about Excel >> Access transfer, but if you set up your database structure in Access, declaring your variables as reals, strings, booleans etc., then the data could be recognized as such. Another possibility is that the macro you wrote exports the data as text, not as values or other data types. If this is the case, then it is quite normal that if no database structure and data types have been defined in access, every variable is considered as text. I don't know if this is of much help, but maybe this will help you finding the answer to your problem.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exported spreadsheet contain ' (Excel 2000)

    Can you upload an example workbook with your macro?
    Legare Coleman

  4. #4
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exported spreadsheet contain ' (Excel 2000)

    I have declared the data types in the source table of the query that Im using to select the data, some data are declared as text, some are numbers and some are dates. The macro command am using is Transfer to spread sheet. But Thank you guys, I think I'll check that again and get back to you guys if I have more problems

    <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exported spreadsheet contain ' (Excel 2000)

    If the problem is in your macro, it may be due to spaces. Make sure that you trim all leading and tailing spaces for values that you want to export as numbers.

Posting Permissions

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