Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ntn104
Posting Yak Master
175 Posts |
 Posted - 2011-04-05 : 10:26:29
|
| Hello,How would I append data from excel to access table if different data type? For example:access table datatype:AUTONUMTEXTDATA/TIMETEXTNUMBERNUMBERTEXTTEXTTEXTexcel table:Numbertextnumbernumbernumbernumbernumber I got error message for data type mismatch...but I could not change datatype in excel to work...please advise thanks, |
|
|
SMerrill
Posting Yak Master
206 Posts |
Posted - 2011-04-29 : 18:37:03
|
| There is not enough information here to answer your question. Please include a snip of your Excel spreadsheet, and there will be a process to convert it.Often, a developer simply imports everything from Excel as text, then transforms it once it gets into Access.~ Shaun MerrillSeattle area |
 |
|
|
|
|
|
append data